[TYPO3-v4] List module improvements

[Jigal van Hemert]

Hi,

On 7-3-2011 11:48, Dmitry Dulepov wrote:
> However this does not really affect the search speed, only amount of
> records and distribution of pid values does. The more different pids,
> the more chances that mysql will prefer full table scan even if a
> good index exists.

The opposite is actually true: if there are not enough different pids 
(low cardinality) it is faster to do a full table scan (chances are that 
you need to retrieve a lot of records anyway) than to use an index.

The command ANALYZE TABLE analyzes and stores key distribution for a 
table. This helps MySQL take such decisions. Unfortunately database 
maintenance is not something which is done on a regular basis in real life.

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert
skype:jigal.van.hemert
msn: jigal at xs4all.nl
http://twitter.com/jigalvh