I enabled devel to Display query log

UPDATE: this problem only happens for logged users

I found that the Frontpage generate 900 queries.

**67** of them generated by the **Locale** module


**480** of them are of the type: **DrupalDatabaseCache::set**

How can I track this problem?

I read that I should disable the i18 module, but I can't do this since it is a multilingual site and I there are other modules that need the i18 module.

This only happens in the Frontpage in other pages the queries downs to 300.

  • Why do you think it's a problem? And what do you have on frontpage that you don't have on other pages?
    – Mołot
    Feb 6 '14 at 11:04
  • Just regular content in the frontpage, some text, images. No blocks, nothing. I think it is a problem because the frontpage takes 10 seconds to fully load.
    – chefnelone
    Feb 6 '14 at 11:08
  • @Mołot Don't you think tha 480 queries of the DrupalDatabaseCache::set type is too much?
    – chefnelone
    Feb 6 '14 at 11:09
  • 1
    @chefnelone DrupalDatabaseCache::set is invoked by cache_set(), so that's what you're looking for
    – Clive
    Feb 6 '14 at 12:01
  • 1
    I found it! It is the theme. I just change the theme and the queries downs to 175.
    – chefnelone
    Feb 6 '14 at 12:39

Problem was in theme. I change to the site Bartik theme and the problem was gone.

I'm using the commerce kickstart distribution if that helps someone. I run into other issues in the past with the frontpage in this distribution. I just remember that and that is why I thought it could be a problem related to the theme. The theme of this distribution has some lines in the preprocess file and that imho may be the source of the problem.

I my situation I will use other theme since I don't need a responsive theme at all.


If performance is an issue then consider tuning Drupal a little. Here's a recent optimization tips for Drupal I did just a few minutes ago. Then you can run your site with all it's queries and wonderful, useful modules with less pain.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.