To set database properties that optimize database performance
About this task
You can set database properties to optimize database performance and to reduce database size. Set database performance properties by opening the Database Properties box on an existing database or as you create a database.
Make sure you fully understand these database properties before changing their settings.
Procedure
- Make sure you have Designer or Manager access in the database ACL.
- Do one of the following:
- Open a database and choose File - Application - Properties.
- As you create a new database, click the Advanced button.
- Select or deselect properties listed in the table that follows.
- After you select any of these three properties, compact
the database for the property to take effect:
- Don't maintain unread marks
- Optimize document table map
- Don't support specialized response hierarchy
Results
| Property |
Tab |
To optimize performance/size |
Improves database performance? |
Reduces database size? |
|---|---|---|---|---|
| Allow use of stored forms in this database |
Basics |
Deselect option |
Yes |
Yes |
| Display images after loading |
Basics |
Select option |
Yes |
No |
| Don't maintain unread marks |
Advanced |
Select option |
Yes |
Yes |
| Optimize document table map |
Advanced |
Select option |
Yes |
No |
| Don't overwrite free space |
Advanced |
Select option |
Yes |
No |
| Maintain LastAccessed property |
Advanced |
Deselect option |
Yes |
No |
| Don't support specialized response hierarchy |
Advanced |
Select the option |
Yes |
Slightly |
| Don't allow headline monitoring |
Advanced |
Select the option |
Prevents performance degradation |
No |
| Limit entries in $UpdatedBy fields |
Advanced |
Select the option and specify the number of entries $UpdatedBy fields can contain |
Yes |
Yes |
| Limit entries in $Revisions fields
|
Advanced |
Select the option and specify a limit on the number of entries $Revisions fields can contain. The suggested limit is 10 entries. |
Yes |
Yes |