[TYPO3-dev] Web->list very slow if tt_news-records and admin

[Jigal van Hemert]

Hi,

On 1-9-2011 15:02, Christian Kuhn wrote:
>> SELECT COUNT(*)
>> FROM tt_news
>> WHERE
>> l18n_parent=21193 AND sys_language_uid!=0 AND deleted=0
>
> Most simple solution: Add a key on l18n_parent field of tt_news table,
> it will speed up the query a lot.

Isn't this a general problem with the list module and extension records? 
Maybe it's a good feature for the kickstarter to add such indexes 
automatically when generating the tables in a new extension.

http://bugs.typo3.org/view.php?id=18264

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.