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

[Ries van Twisk]

Dmitry Dulepov wrote:

>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.
>  
>
We have about 2500 pages in hour system.
I think this amouth is a good starting point to optimize queries and 
indexes.
My own site has just over 20 pages I think. There was no change seen 
from there.
However on my 2500 pages site the page generation time whent down from 
about 8-9 seconds
to like 3-4 seconds. Sometimes hard to measure on a buzy server.
But it really helps.

Under postgresql you need to tell the RDBM to analyse the database first 
and then you can use
explain to ask postgresql how the queries are going to performed and 
what indexes postgresql is
going to use. Bottom line for that is that you need a lot of data before 
any RDMB can optimize
and this will also highly depends on the number of rows.

Slow queries personally don't tell me anything (under mysql this is just 
a time thing, right?)
but explain select does tell me a lot on what a RDBM things is right to 
optimze the query, eg what indexes
to use.

The proposed indexes send by.... was a really good starting point for this!

Ries

-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
=== Work:
email: ries at livetravelguides.com
web:   http://www.livetravelguides.com