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, 2014 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, 2014 at 11:08
  • @Mołot Don't you think tha 480 queries of the DrupalDatabaseCache::set type is too much?
    – chefnelone
    Feb 6, 2014 at 11:09
  • 1
    @chefnelone DrupalDatabaseCache::set is invoked by cache_set(), so that's what you're looking for
    – Clive
    Feb 6, 2014 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, 2014 at 12:39

2 Answers 2


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 and acknowledge you have read our privacy policy.

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