Issue Feature Closed

#24110Performance Tunning : rewrite/clean t3lib_db->listQuery

Popy no-lastname-given 11/17/10, 17:42 updated 11/22/10, 21:34

Description

Actually the listQuery method is based on 3 “LIKE” separated with OR, so there’s 3 string comparaisons instead of just one.

Solution should be :
  • using “concat” to add comma before and after field value THEN compare this result to the “,value,” string
  • using mysql builtin FIND_IN_SET function

(issue imported from #M16451)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.