Hello,

I have a site with drupal commons, and its very very slow. When I show the logs I have four calls to DrupalDatabaseCache::getMultiple

They are
40.78 DrupalDatabaseCache::getMultiple SELECT cid, data, created, expire, serialized FROM cache_entity_node WHERE cid IN (:cids_0, :cids_1, and so on... going all the way to cids_1398

Then there is another query 14.83 DrupalDatabaseCache::getMultiple
Then another 13.89 DrupalDatabaseCache::getMultiple
Then another 11.74 DrupalDatabaseCache::getMultiple

Please help, I tried multiple servers, they are fast, I tried memcahced and apc as well with no luck.

Thanks,

Comments

mariusm’s picture

mariusm CreditAttribution: mariusm commented

For hosting shared use boost https://www.drupal.org/project/boost
On dedicated servers, you may want to consider Varnish instead.

knigh7’s picture

knigh7 CreditAttribution: knigh7 commented

Its very fast for anonymous users, its only slow when logged in.

mariusm’s picture

mariusm CreditAttribution: mariusm commented

In this case it is very very slow for me

blogers’s picture

blogers CreditAttribution: blogers commented

Me other user with problems DrupalDatabaseCache::getMultiple multiple