Optimize Database
Digest
Optimize Database is an option that appears only for administrators. Running this function will clear all audit information, clear all log-in history, clear all read messages, clear smart publishing information, remove old versions of assets, remove orphaned records; it is not recommended to be run frequently.
Technical
To Access Optimize Database
- When you are logged in as an Administrator, select the System Menu from the top left navigation bar.
- Select Utilities from the drop-down menu.
- Select Optimize Database
- Select the check boxes for the functions you wish to perform.
The options when optimizing the database are:
- Clear all audit information - removes all audits from the database.
- Clear all login history - removes all audits for logins, logouts, and failed login attempts from the database.
- Clear all messages - removes all messages which have been marked as Read from the database.
- Clear smart publishing information - removes all cache information used to intelligently decide when a published file needs to be re-transmitted to the destination server.
- Remove old versions of assets - removes all but the current version of all version-capable assets from the database.
- Remove orphaned records - removes all child records from the database that are no longer referenced by a parent record (e.g. blobs, metadata, page configurations, page regions, etc.).