Optimizing a Database

Note
This procedure is not available for workspaces.

In the Component Manager, open the Tools menu, point to Database and select Performance Utilities.
The Database Info dialog window opens. Once you activated one option, the Execute button appears.

Activate one or more of the options.

Optimize

Used to defragment the database.

Convert

Used to rewrite the database, thus improving access speeds.

In most cases, regular optimization will be enough to keep the performance of your database at an acceptable level. You should only consider converting the entire database if you encounter serious problems with performance.

Note
Converting a large database can be very time-consuming. It is recommended to run this as an overnight process.

Repair

Used to rebuild the database from scratch. Damages of your database, e.g., destroyed references, are repaired.

Note
Repairing a database always includes the Optimize and Convert operations, the corresponding options are blocked.

Check

Used to verify the structures and references in the database while logging the results in the monitor window.

Click the Execute button.
The selected database management program is started. The results are shown in the ASCET monitor window.
Click OK to close the message window.