[TYPO3-core] RFC #14818: Performance: Use mysql find_in_set-function in t3lib_db->listQuery()

[Xavier Perseguers]

Hi,

> Problem:
> The function listQuery() uses a like-construct to find a value in a
> comma-seperated list.
> Mysql has a internal function for this called 'find_in_set'
> This is 2.5 times faster.
>
> Solution:
> change the t3lib_db->listQuery(), using the mysql-function find_in_set
> instead of the like-construct.
> adding the funcion listQuery() to the dbal ux_t3lib_db class with the
> like-construct.

Committed attached patches to:

- Core trunk (rev. 8197)
- DBAL trunk (rev. 35747)

Thanks to Caspar for this patch and to others for the interesting points 
in discussion.

Xavier
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 14818_core_v3.diff
Type: text/x-diff
Size: 1663 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100716/cd35b6e7/attachment-0002.diff>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 14818_dbal.diff
Type: text/x-diff
Size: 712 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100716/cd35b6e7/attachment-0003.diff>