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
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english