[TYPO3-dev] list module hangs at 1 million records

[Dmitry Dulepov [typo3]]

Hi!

Franz Holzinger wrote:
> It is about 7 seconds now instead of 31 seconds we had before. It has
> got 4-5 times faster than before.
> 
> With EXPLAIN this gives:
> 
> id 	select_type 	table 	type 	possible_keys 	key 	key_len ref 	rows 	Extra
> 1 	SIMPLE 	tx_largetable 	range 	parent 	parent 	4  NULL 	1665224 	Using
> where; Using filesort
> 
> It has only used the key 'parent', but it did not use the 2 additional
> keys 'crdate' and 'sorting'.

Reminder: MySQL uses only one key at a time. This is why composite index is better. You can create 10 keys and still only one will be used for a query.

-- 
Dmitry Dulepov
TYPO3 Core team
More about TYPO3: http://typo3bloke.net/
Subscribe: http://typo3bloke.net/rss.xml
Latest article: http://typo3bloke.net/post-details/extension_updates_loginusertrack_and_comments/