SHOW DATABASES is slow

[Err]

SHOW databases

The above query is slow on shared MySQL hosts. Is there any way I can use a different method that would be faster in general?

[Mudsaf]

This prob pretty much all you can do (In my opinion).http://dev.mysql.com/doc/refman/5.0/en/show-databases.html

[sumbin]

SHOW databases

The above query is slow on shared MySQL hosts. Is there any way I can use a different method that would be faster in general?

if you want to show all the databases present in your mysql-server you need the query "show databases", if in your server the no. of database are large then it wil definitely take time to execute the query.if you want show few databases of your choice you can use LIKE clause..e.g. " show databases like '<search key word>%' " i.e. show databases like '<user>%' , the above query will show all the databases starting with user