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

Xavier Perseguers typo3 at perseguers.ch
Sat Jul 17 12:24:27 CEST 2010


Hi,

> Meaning that if we need mapping for table/field names and we already
> replace the functions such as LOCATE or FIND_IN_SET with their
> equivalent the first time we parse the string, the SQL parser won't be
> able to parse the query the second time unless we add support for
> non-MySQL SQL in Core's SQL... This is why there is this
> $functionMapping flag...

FYI, currently working on a PoC that parsing the queries twice may be 
avoided and would then speed up DBAL, at least with Oracle:

http://bugs.typo3.org/view.php?id=15160

Xavier


More information about the TYPO3-team-core mailing list