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

[Dmitry Dulepov [typo3]]

Hi!

Franz Holzinger wrote:
> Yes, indeed.
>  0.1097 sec.
> But this is with additional index:
>  deleted  	 INDEX  	 1   	 deleted
> 
>  0.0014 sec
> This is after the deletion of the index deleted. This is strangly much
> faster than with the index.

Nothing strange if you read my yesterday's explanation about indexes.

I wrote yesterday that MySQl will skip to full table scan if it believes that index will not speed up query. I also explained yesterday why index on deleted is not useful at all. Nothing strange.

You could speed up things already yesterday if you followed my advice on composite index.

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