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

[caspar at gosign.de]

I forgot to attach the patch, sorry

> This is an SVN patch request.
>
> Type: Performance
>
> Bugtracker references:
> http://bugs.typo3.org/view.php?id=14818
>
> Branches:
> Trunk
>
> 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.
>
> Greetings
> Caspar
>
> _______________________________________________
> Before posting to this list, please have a look to the posting rules
> on the following websites:
>
> http://typo3.org/teams/core/core-mailinglist-rules/
> http://typo3.org/development/bug-fixing/diff-and-patch/
> _______________________________________________
> TYPO3-team-core mailing list
> TYPO3-team-core at lists.typo3.org
> http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-team-core
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bug_14818.patch
Type: text/x-patch
Size: 2149 bytes
Desc: not available
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20100703/2e49f3ba/attachment-0001.bin>