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

[Stefan Frömken]

Am 01.09.2011 15:16, schrieb 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
>
@Christian:
WOW...that's what I call "fast" :-) Thank you.

@Jigal: Isn't it better to open a new bug on forge? Or does I 
misunderstood something?

Stefan