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

[Jigal van Hemert]

Xavier Perseguers wrote:
> However as our compatibility functions for MSSQL and PostgreSQL are not 
> 100% the same as the MySQL one (it basically returns true or false but 
> not the actual position of the item in the list, which should be OK I 
> guess with our use in TYPO3), forcing the user to add "!= 0" would be 
> better. I'll change the DBAL patch to not automatically add this 
> comparison string (see related issue in bug tracker if you're interested 
> in).

I think it is not really a problem as long as it's documented.

For DBMSs which do not have a comparable function DBAL could convert it 
to the hideous triple like construction.

Which reminds me: once DBAL supports FIND_IN_SET() enableFields could be 
modified to make use of it instead of the triple-LIKE.

> their install working. For this I'll have to test my DBAL patch on other 
> DBMS first.

We'll wait for the tests :-)

-- 
Jigal van Hemert
skype:jigal.van.hemert
msn: jigal at xs4all.nl
http://twitter.com/jigalvh