[TYPO3-dev] rfc: minor db change for TS templates

Dmitry Dulepov dmitry at typo3.org
Wed Oct 4 19:32:11 CEST 2006


Hi!

Martin Kutschker wrote:
> The EXPLAIN returns the same. But of course you're right Mysql should 
> not read the row to handle the WHERE. But it seems to work on the index 
> alone you have to use only indexed columns in the SELECT. Here we use *, 
> so AFAIKS Mysql does no further optimization.

Yes but if all fields are in the index, it means that mysql need not to 
look to actual rows to find the right row. Looking in the index is much 
faster.

> My conclusio: In theory your index should be faster, but in practice it 
> isn't.

I think it is possible to evaluate only by runing dedicated test.

-- 
Dmitry Dulepov

Web: http://typo3bloke.net/
Skype: callto:liels_bugs

"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)




More information about the TYPO3-dev mailing list