[TYPO3-english] Slow Queries From TT-News
Jigal van Hemert
jigal at xs4all.nl
Mon Nov 14 22:33:14 CET 2011
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.
More information about the TYPO3-english
mailing list