[TYPO3-dev] Improve DB performance

[R. van Twisk]

Martin Kutschker wrote:
> Dmitry Dulepov schrieb:
>   
>> Peter Russ wrote:
>>
>>     
>>> As often query results are sorted by sorting or crdate or tstamp it 
>>> might be helpful if at least this fields in tables pages and 
>>> tt_content would be indexed. At kickstarter this should be also 
>>> included per default.
>>>
>>> Not tested, but I guess it might help.
>>>       
>> Firsts, we need to log typical queries. Then we can see what indexes 
>> would be most welcome. If you have time, can you do it?
>>     
>
> How to do this?
>
> Hack into t3lib_db or make an XCLASS and add logging code to the queries: 
> log the query and the execution time together with the session key to be 
> able to see what queries belong to one page hit.
>
> Masi
> _______________________________________________
>   
Appart from that,

don't forget to turn of any query cache during testing so
only raw results get recorded. It might also be a good idea
to log to the file system instead of the database itself.

Ries