INFORMATION_SCHEMA Hanging

bettondesign

New Member
Hi

I have recently been having problems with Mailing List Manager where it cannot pull in information from the MySQL database. I have the script hosted on a shared server. I have asked my host to look into the problem and this is their response:

Your system is hanging on the following query:

SELECT UPDATE_TIME FROM INFORMATION_SCHEMA.TABLES WHERE table_name='tbl_mlm_sub'

Generally, querying the INFORMATION_SCHEMA should be avoided at all costs - These are shared servers so have thousands of databases, the more databases that are added the slower queries against INFORMATION_SCHEMA become. Is there anyway this can be modified?
Can I modify this and if so, how?
 
Top