[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