[TYPO3-core] Speed up of page cache

[Peter Niederlag]

Hi,

Dmitry Dulepov schrieb:
> Hi!
> 
> I was able to speed up page cache quite a lot by adding index on "expire" field
> in cache_pages. One moment a single instance of mysql 3.23 started to get around
> 400 request/second and sites were running slowly. Immediately after altering
> cache_pages table with phpMyAdmin it ran significally faster.
> 
> I do not know where cache_pages structure is defined but it may be good to make
> such change there.

No Opinions/knowledge?

I dont't see why an index on expire could help, INDEX on page_id and
hash is already enabled.

Cheers,
Peter
-- 
Peter Niederlag * Neuer Sandberg 9 * 31535 Neustadt *
Fon (privat): 05036 / 924 100 * Fon (Büro): 05036 / 924 101
Fon (mobil): 0172 / 516 48 55 * Fax 05036 / 924 105
callto:typo3support (skype)
http://www.niekom.de * TYPO3 und EDV Dienstleistungen *
http://www.clown-goli.de * Clown-Comedy-Jonglage-Animation *