SQL - Re: [Typo3-dev] New Memory Requirement for Extensions

[Martin T. Kutschker]

Kasper Skårhøj wrote:
> (Same for SQL indexes optimization!)

I recommend delaying any such optimiziations after DBAL has landed.

Ok, not really necessary, but the current thin DB layer should IMHO be 
enhanced directly or XCLASSed first. *) Otherwise you stumble across 
haphazardly creating indices.

So you can see a) what queries are being extecuted and b) how long they 
  take to execute. Plus you see what queries are common.

Masi

*) Kasper, what's the best approach for this? Another way is to use 
hooks for profiling queries.