View Single Post
  #1 (permalink)  
Old 07-18-2008, 10:34 AM
edhan's Avatar
edhan edhan is offline
WebProWorld Veteran
 

Join Date: Aug 2003
Location: Singapore
Posts: 581
edhan RepRank 1
Question Optimize Overhead for database

Hi

Once awhile I will check using phpMyAdmin to check on individual database tables and find there are some overhead for some fields. So I will manual select them and click to optimize.

I find this method is a little troublesome as I have about 100 databases and going through one at a time to check if there are overhead and selecting them to optimize. This really takes up a lot of my time.

So I am wondering if there is a better method where I can do it automatically?

Any suggestion? Or this is the only method?

Thanks!
Reply With Quote