[TYPO3-dev] Optimizing last 20 query

John Angel johnange at gmail.com
Fri Mar 16 08:32:56 CET 2007


> Did you test it? Or is this just an academic answer?

Sure I did. It is even little slower.

Interesting thing is the change in EXPLAIN. The number of rows for the key 
explanation is smaller and type is REF instead of RANGE. That should provide 
faster results, but it isn't.

Maybe mysql will behave better in high traffic env, because number of 
records used is smaller?






More information about the TYPO3-dev mailing list