2012/4/25 Marc Delisle marc@infomarc.info:
Le 2012-04-25 09:19, Michal Čihař a écrit :
Hi all
I suggest another big cleanup of configuration - to remove all MySQL types/functions/operator definitions. We want to be able to change these with upgrades, they also depend on used server and version and I don't see what would user want to configure here besides reordering them.
Any comments on that?
In general I find this a good idea, however I have a case where someone would want to configure.
In $cfg['TextOperators'] one of the choices is 'LIKE %...%'. This generates a non-indexed search, so someone could want to remove it from the list for performance reasons.
It can still be entered manually, and any operator used on unindexed column could be just as bad. IMO you don't give full access to a big database to a person who doesn't know the basics. And if you do, something else is wrong, not the software :)