[TYPO3-dev] Improve DB performance

[Martin Kutschker]

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