[TYPO3-dev] Typo3 Performance

[Martin Kutschker]

R. van Twisk schrieb:
> Dmitry Dulepov wrote:
> 
>> Martin Kutschker wrote:
>>  
>>
>>> PS: Best improvement of course is to reduce the total amount of 
>>> queries used :-)
>>>     
>>
>>
>> Big +1. Why don't we have generic query cache in typo3? Some queries 
>> repeat in BE/FE a number of times. Btw, I like your rootline cache 
>> idea in core list but I think that db cache should be more on t3lib_db 
>> level...
>>
> For mysql databases I am not sure how much time it will really save,
> since mysql has it's own query cache already. This is the same for other
> databases of course which uses other methods to cache results.

To take advatange of query cache you have to repeat the VERY SAME query.

> I think we can get more speed out of setting indexes correctly, we might 
> consider
> a storing all queries in a database and the time it took to execute the 
> query
> or  filesystem (option can be turned off or on) and then based on the 
> acquired data
> we can create some statistics . Based on that it might shed some light
> on where to place indexes.

That's the only way to do tuning. Remember to use a large installation for 
that.

Masi