[Phpmyadmin-devel] SHOW DATABASES on ISPs

[Sebastian Mendel]

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