[TYPO3-english] Slow Queries From TT-News

[Jigal van Hemert]

Hi,

On 9-11-2011 21:04, Louis Coppola wrote:
> tt_news.endtime>1315613160) 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'))

Which version of TYPO3 are you using here? Since 4.5 these constructions 
are replaced with FIND_IN_SET(). Maybe that's reason enough for you to 
upgrade?

By the way: for other databases DBAL uses appropriate functions or 
replacements when FIND_IN_SET is used.

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert.