[TYPO3-core] FYI #14985: FIND_IN_SET should be used instead of complicated LIKE where clause
Xavier Perseguers
typo3 at perseguers.ch
Fri Jul 16 15:27:56 CEST 2010
Hi,
FYI, the following patches were committed to:
- Core trunk (rev. 8196)
- DBAL trunk (rev. 35742)
Type: feature / requirement for RFC #14818
Branches: trunk (both Core and DBAL)
Bugtracker reference:
http://bugs.typo3.org/view.php?id=14985
Problem:
In order to speed up search in lists of comma-separated value, MySQL's
FIND_IN_SET() function should be used. Those patches add support for it
to the Core's SQL parser and rewrite methods in DBAL.
Cheers
Xavier
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 14985_core_v2.diff
Type: text/x-diff
Size: 2501 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100716/d0d25ca5/attachment.diff>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 14985_dbal_v2.diff
Type: text/x-diff
Size: 9863 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100716/d0d25ca5/attachment-0001.diff>
More information about the TYPO3-team-core
mailing list