[Phpmyadmin-devel] Removing MySQL types from config

[Piotr Przybylski]

2012/4/25 Marc Delisle <marc at 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 :)

-- 
Regards,
Piotr Przybylski