INFORMATION_SCHEMA Hanging

[bettondesign]

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?

 

[bettondesign]

Don't worry, I've sorted this as per the instructions in the code of lm_functions.php