[development] Caching, caching, caching...

Dries Buytaert dries.buytaert at gmail.com
Fri Jul 14 18:15:11 UTC 2006


>> 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?  If we can make some simple assumptions, we might be able  
to save a helluvalot database queries (per page view) ...  Food for  
thought.

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



More information about the development mailing list