[development] Caching, caching, caching...

[Dries Buytaert]

On 12 Jul 2006, at 00:01, Gerhard Killesreiter wrote:
> Now the question is if we want to go down this road. To properly
> invalidate the cache requires to implement all sorts of hooks (forum
> module needs _comment and _user for example) which you would not need
> otherwise. This complicates the code quite a bit.

Personally, I'd not optimize with MySQL's query cache in mind.  If  
the folks at MySQL improve their query cache implementation, our  
efforts might have been moot.  I'd focus my energy on high-level  
improvements, rather than low-level improvements.  That is, I'd focus  
architectural changes that reduce the number of SQL queries or that  
simplify complex queries (eg. less joins).  For example, the node  
table and node_comment_statistics table have a one-on-one relation  
and could potentially be merged.  I'm not sure what it would buy us,  
but it might be worth it.

Maybe we should run the modified devel.module on drupal.org to see  
what the most expensive queries are?  You know, accumulate results  
over multiple page views.  Do we have recent data query data from  
drupal.org?  Let's start by identifying some key bottlenecks.

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