13 Aug
2004
13 Aug
'04
8:18 p.m.
Have a look at a more detailed explanation: https://sourceforge.net/tracker/index.php?func=detail&aid=1008507&gr...
Marc Delisle wrote:
Hi,
We got some negative reports about putting this operator first in the list. Concerns are about performance (wildcard being slower, and in case of monster tables, slower meant > 45 min.).
Before those reports, I was finding that putting LIKE '%...%' first was quite useful, as I almost always put the % manually for any search I do.
I suggest for the next -rc to put back LIKE in the first position, followed by LIKE %...%.
We could also move the list of operators from tbl_select.php to config, but this would probably be too much.
Comments?
Marc