[development] Caching, caching, caching...
kb at 2bits.com
Fri Jul 21 13:24:46 UTC 2006
On 7/21/06, Dries Buytaert <dries at buytaert.net> 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 have to agree with Moshe on this. This just increases the "special cases"
we have, and that can be trouble down the road.
Moreover, the list can vary from one site to the other ...
More generic solutions are better.
More information about the development