Re: [Phpmyadmin-devel] SHOW DATABASES on ISPs

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