[TYPO3-dev] TYPO3 4.1 INNODB

[Steffen Müller]

Hi Dmitry,

thank you for your explanation.

On 01.03.2007 11:01 Dmitry Dulepov wrote:
> 
> But there is one more advantage for Innodb. Myisam keeps indexes
> separately from row data. Thus if row pointer is found, myisam engine
> has to do one  more seek to data. Innodb keeps indexes together with
> rows, so it does not have to seek again.
>

This is only true for the primary index. Secondary indices are not
clustered and thus need also one more seek, too. (see Zawodny/Balling)
But I don't have a clue, if this is relevant for TYPO3.

-- 
cheers,
Steffen