Optimize Database

Introduction

AutoGallery SQL's database optimize function allows you to "cleanup" the MySQL database tables that it uses so they are optimized for both speed and disk usage. In general, you will not need to run this command more than once every few weeks, as MySQL is quite efficient in maintaining it's datafiles. The only time you may need to run it more often is if you delete a large number of galleries from your database.

Optimizing Your Database

To optimize your database, simply click on the Optimize Database link in the Setup section of the control panel menu. A small window will pop-up and let you know that the procedure is in progress and it will tell you when it is done. There is nothing further that you need to do, your MySQL database optimization is complete.