[Phpmyadmin-devel] SHOW DATABASES on ISPs

Hi,

SHOW DATABASES seems somehow slow on ISPs

how about using I_S.SCHEMA_PRIVILEGES

f.e.

SELECT * FROM `SCHEMA_PRIVILEGES` LIMIT 0 , 30

performs much faster on the ISP i could test:

0.08 sec vs. 0.24 seconds

possible this will only work with ISPs where are no anonymous rights

possible a configuration where ISP can use I_S.SCHEMA_PRIVILEGES instead of SHOW DATABASES, or they can switch to SHOW DATABASES like '[user]_%' which performs much faster too

how about

$cfg['DatabaseListQuery'] = 'SHOW DATABASES'; // #user# is replaced by curent user $cfg['DatabaseListQuery'] = "SHOW DATABASES LIKE '#user#%'"; $cfg['DatabaseListQuery'] = 'SELECT DISTINCT TABLE_SCHEMA FROM `SCHEMA_PRIVILEGES`';