{SPAM 01.8} Re: [development] Caching, caching, caching...

[Dries Buytaert]

On 21 Jul 2006, at 15:15, Moshe Weitzman wrote:
> i can't think of any reasonable assumptions. to me, the waste is  
> not that we have to perform so many queries, but rather that we do  
> so on every page view  even though the data rarely changes. to  
> address that, one should use mysql query cache or even memcached.

A query cache only eliminates part of the overhead.  Most of the  
overhead comes from Drupal's database abstraction layer, not from  
execution the actual SQL query:

   http://buytaert.net/drupal-database-interaction

We gain most if we eliminate calls to db_query().  We use a MySQL  
query cache on drupal.org, and the one query that retrieves the URL  
alias is still to most expensive query (accumulated cost).

> fyi, devel.module just got the ability to do query logging to the  
> DB. killes and i just need to quash one silly bug and it will be  
> ready.

Does it (still) accumulate data across different page views?

--
Dries Buytaert  ::  http://www.buytaert.net/