[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`'; -- Sebastian