[development] Caching, caching, caching...

Gerhard Killesreiter gerhard at killesreiter.de
Fri Jul 14 18:22:56 UTC 2006

Dries Buytaert wrote:
>>> Maybe we should run the modified devel.module on drupal.org to see 
>>> what the most expensive queries are?
>> SELECT * FROM url_alias, I'd be surprized if that had changed. The 
>> individual query is very short but there are probably 120 per page on 
>> average.
> Are there reasonable assumptions we can make about certain URLs?  Like, 
> can we assume that people don't want to alias '?q=qcomment/reply/123'?  


> Or ?q=contact?  Or q=user/register and ?q=user/password? 

I always alias those for sites in German.

> If we can make 
> some simple assumptions, we might be able to save a helluvalot database 
> queries (per page view) ...  Food for thought.

Frankly, I don't think we will get a lot of agreement on what can be 
aliased and what not. We might be able to devise a solution that works 
similar to the translations cache on a per page basis.


More information about the development mailing list