If your website has a moderate to large number of visitors, you should tune your website for maximum performance. This will ensure that all your visitors have a positive experience, and are not frustrated by delays in loading pages or accessing the website.
We will discuss ways to optimize both the backend database, and the frontend of the website that displays the information to the visitor.
In this section we'll optimize our MySQL database tables using the DB Maintenance module.
Optimize the database where your site content is stored, to ensure the best possible performance.
DB Maintenance (http://drupal.org/project/db_maintenance)