[drupal-devel] Menu cache

[Gerhard Killesreiter]

On Tue, 10 May 2005, Gerhard Killesreiter wrote:

> On Tue, 10 May 2005, Dries Buytaert wrote:
>
> >
> > We found that on drupal.org, the SQL query to load the menu cache
> > sometimes takes 50 ms or more to complete (normally, a query takes 0.3
> > ms to complete):
> >
> > mysql> SELECT data, created, headers, expire FROM cache WHERE cid =
> > 'menu:<uid>:en'
>
> According to database.mysql there is no index on cid. Can you try adding
> one? Length 15 or so should do.

For assitional sql-karma we could also split up the cache table into
several tables as I suggested a few times in the past:

cache_menu
cache_locale
cache_filter
cache_page
cache_misc

Selects from smaller tabels _are_ faster.

Cheers,
 	Gerhard