[drupal-devel] Menu cache
killesreiter at physik.uni-freiburg.de
Tue May 10 14:22:26 UTC 2005
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:
Selects from smaller tabels _are_ faster.
More information about the drupal-devel