[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