[TYPO3-ttnews] tt_news generating slow queries

[Marcus 'biesior' Biesioroff]

W dniu 10-12-10 09:40, Piotr Burda pisze:
> ...AND (tt_news.fe_group='' OR tt_news.fe_group
> IS NULL OR tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR
> tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR
> tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR
> tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR
> tt_news.fe_group='-1')) AND sys_language_uid IN (0,-1);
>
> all parameters are same, only starttime and endtime are changing.
> Which part or tt_news is generating it and why?

Witaj Piotrze ;)

The above conditions are added by TYPO3 not by tt_news itself (in big 
general), and they're required to check FE users and groups perrmisions 
for records (news, pages, contents, etc.) and you shouldn't remove these 
while you require to show some content only for some logged users/groups...

However (there's always some 'however' in TYPO3 :) ) you can remove 
these conditions (at least bigger part of it) on the pages, where 
there's no content for logged users required at all.

To do that just edit page properties in BE and change the Login Mode (on 
Access tab) to: 'Disable user login completely', after that you should 
gain some performance improvement.

ps. you missed last TUG ;)

-- 
Marcus 'biesior' Biesioroff
http://www.typo3.pl | TYPO3 Polish Community
T3CI