10 May
2005
10 May
'05
4:22 p.m.
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