[TYPO3-dev] Testing TYPO3 caching vs.[FE][pageCacheToExternalFiles]

[Dmitry Dulepov]

Hi!

Martin Kutschker wrote:
> I have the feeling that we are basically agreeing, but having troubles
> to see that. I'm no native speaker and from your name I gues you aren't.

Yes (meaning not native speaker) :)

> My point is that you cannot make good indices without data. You need a
> real world data to make indices. If you want to ship Mysql with good
> all-purpose indices you must collect some stats on average DB usage.
> IMHO it won't do any good to add indices just because it "feels right"
> to add some.

Fully agree.

> This is why I say no to adding indices to "deleted" and "hidden". If it
> can be proven that there is a performance beneift (where? BE? FE? page
> rendering? ...) then add it. If you cannot prove it, don't add it.

I can say it helped me a bit. But this was a very small bit. I just
finished with installing new server and may be will spend more time on
playing with indexes. I have database with four sites and over 5000
pages. I plan to load it with requests, try EXPLAINs and see what
happens if I add combined indexes.

~9 rq/s (typo3) ~against 1000 rq/s (static content) just killed me two
days ago :( We definitely need optimization...

Dmitry.
-- 
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)