[TYPO3-english] Slow Queries From TT-News

[Xavier Perseguers]

Hi,

> It's no problem to use LIKE, but if you are using LIKE with a wildcard
> at the beginning (LIKE '%,0') MySql is unable to use the index.
> http://dev.mysql.com/doc/refman/5.1/en/mysql-indexes.html

The big problem comes from having to deal with comma-separated values to 
reference records (here fe_groups) instead of real foreign keys.

Hopefully, more and more extensions will have a better scheme.

Unfortunately, this is unlikely to happen for TYPO3 Core itself as it 
would break virtually too many extensions or would probably mean have a 
non-negligible overhead to have some fallback for them (scheduler job?).

Cheers

-- 
Xavier Perseguers
Release Manager TYPO3 4.6

TYPO3 .... inspiring people to share!
Get involved: http://typo3.org