Seems the DH admins have created a index
one DB has 150,000 rows so I have asked on the CMS forum how to remove old posts to get around this one
Please enable caching for the software using this
Unsure how to do this for mysql but CMS's that have tables disabled are using caches for the rest of the CMS
One site had some bad mysql queries that use a lot of joint tables. This needs to be rewritten but will take a lot of time.
Thanks for your reply