[TYPO3-english] Slow Queries From TT-News

Xavier Perseguers xavier at typo3.org
Mon Nov 14 19:58:53 CET 2011


> 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?).


Xavier Perseguers
Release Manager TYPO3 4.6

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

More information about the TYPO3-english mailing list