On 10 May 2005, at 14:53, Gerhard Killesreiter wrote:
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.
We have an index: mysql> EXPLAIN SELECT data FROM cache WHERE cid = 'menu:9446:en'; +-------+-------+---------------+---------+---------+-------+------ +-------+ | table | type | possible_keys | key | key_len | ref | rows | Extra | +-------+-------+---------------+---------+---------+-------+------ +-------+ | cache | const | PRIMARY | PRIMARY | 255 | const | 1 | | +-------+-------+---------------+---------+---------+-------+------ +-------+ -- Dries Buytaert :: http://www.buytaert.net/