[TYPO3-english] Slow Queries From TT-News
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.
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?).
Release Manager TYPO3 4.6
TYPO3 .... inspiring people to share!
Get involved: http://typo3.org
More information about the TYPO3-english