[TYPO3-core] Speed up of page cache

[Martin Kutschker]

Dmitry Dulepov <dima at spamcop.net> writes on 
Tue, 17 Jan 2006 10:07:06 +0100 (MET):

> Hi!
> 
> Peter Niederlag wrote:
> 
> > I dont't see why an index on expire could help, INDEX on page_id
> > and
> > hash is already enabled.
> 
> Probably because this field also participates in query... I tried
> "EXPLAIN" yesterday on my test database (only a few entries), it did
> not use index on "expires" field. But "EXPLAIN" is not 100% the same
> way as query works in the real environment on the same table.


Size of tables matter (use ANALYZE TABLE to tell Mysql the table stats).

Masi