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

[Christian Kuhn]

Hey,

On 09/01/2011 01:09 PM, Stefan Frömken wrote:
> enabled debugging for table tt_news which tolds me that following query
> was executed for each record and needs round about 270 Milliseconds:
>
> 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.

Regards
Christian