[Phpmyadmin-devel] SHOW DATABASES on ISPs

[Marc Delisle]

cand. inf. Alexander M. Turek a écrit :
> Hi there,
> 
> Sebastian Mendel schrieb:
>> SHOW DATABASES seems somehow slow on ISPs
>>
>> how about using I_S.SCHEMA_PRIVILEGES
> 
> What about information_schema.SCHEMATA? I guess, that's the purpose of 
> that view.
> 
>> possible a configuration where ISP can use I_S.SCHEMA_PRIVILEGES 
>> instead of SHOW DATABASES,
> 
> Switching from SHOW queries to information_schema is a good idea, imho. 
> Since the next version of phpMyAdmin won't support MySQL 4.x anymore, I 
> don't see, why a config parameter is needed for that switch.

See the various speed problems about information_schema here: 
http://bugs.mysql.com/bug.php?id=19588

Even if it's fixed in 5.1.22, we don't plan to have 5.1.22 as a minimum 
MySQL version, do we?

Marc