[development] Caching, caching, caching...
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
> 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