[TYPO3-ttnews] tt_news generating slow queries

[Piotr Burda]

On 2010-12-17 18:56, Marcus 'biesior' Biesioroff wrote:
> 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 ;)
>
  Czesc,
Thanks for your help, the problem was based on bad cache configuration.



Regards
Piotr