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

[Franz Holzinger]

Dmitry Dulepov [typo3] a écrit :

> A quick question: how long does it take to run a query on such a long
> table with "WHERE pid=1 AND deleted=0 ORDER BY crdate DESC LIMIT 21,20"?

31.4553 sec. on a dual core AMD Athlon 3700 with phpMyAdmin.

> May be [missing] indexes is a problem? Try adding composite index on pid
> and sorting column (sorting column last!) and see if it helps.
There are already keys:

 PRIMARY  	 PRIMARY  	 1665226 uid
parent 	         INDEX                 	pid

Now I create an index on deleted.

This has unfortunately timed out in phpMyAdmin :-( .
So you cannot even create an index afterwards with this tool.

Franz