[development] Caching, caching, caching...

Earl Miles merlin at logrus.com
Fri Jul 21 14:42:53 UTC 2006


Dries Buytaert wrote:
> 
> On 14 Jul 2006, at 20:15, 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?  If we can make some simple assumptions, we might be able  
>> to save a helluvalot database queries (per page view) ...  Food for  
>> thought.
> 
> 
> Any thoughts here?

I still like my limited url alias cache.


More information about the development mailing list