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

caspar at gosign.de caspar at gosign.de
Sat Jul 3 21:28:13 CEST 2010


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



More information about the TYPO3-team-core mailing list