By Miczka on

Hello everyone,

I'm in charge of a website i did not create, using Drupal 6.16 / php 5.3.2

This website has more than 110 modules enabled...

As I am a Drupal noob, I need help to find solutions for performance issues. Page loading is incredibly long.

I suspected sql queries to slow things down, so I installed the devel module to check on slow queries.

Here's the main output for the front page :
Executed 9090 queries in 934.74 milliseconds. Queries taking longer than 5 ms and queries executed more than once, are highlighted. Page execution time was 4966.4 ms.

It seems totally out of proportion to me...

What would be the next step to tune these queries ? For instance, I can see a query like "UPDATE variable SET value = 's:4:\"/tmp\";' WHERE name = 'file_directory_temp'" is too slow. Where should I go to "repair" this ?

Sorry if I'm being too vague, please don't hesitate to ask for more infos if needed.

Thanks a lot in advance for your help !

⋅ Categories: Drupal 6.x

Comments

WillHall’s picture

WillHall commented

Start by getting rid of all of the modules you don't actually need.

If the site is as big as it is for good reason - then you need to get your cache on.

http://drupal.org/project/boost is a great one.

Miczka’s picture

Miczka commented

Thanks a lot !

I disabled a handful of modules and I installed boost.

Looks like performance got better after that, at least for the total number of queries:

Page execution time was 6067.25 ms. Executed 3686 queries in 1438.41 milliseconds.

Does it seem to you that these are acceptable values ?

I still get slow queries, most of them are related to theme functions and the variable table (used for caching?).
What is the next step? How can I find where those slow queries are called?

I realize my posts are full of "noobism", please be understanding and thanks again

WillHall’s picture

WillHall commented

It is very hard to say without seeing the site.

If you have block cache on, your queries should be cut way down. I would go through and make sure all of your available caching is active - blocks - boost - views - etc.

Then check the times as an anon user.

You may also be suffering from this.

http://www.lullabot.com/articles/drupal-performance-tip-block-visibility