To set database properties that optimize database performance
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.

1. Make sure you have Designer or Manager access in the database ACL.

2. Do one of the following:

3. Select or deselect properties listed in the table below.

4. After you select any of these three properties, compact the database for the property to take effect:

Tip You can use the compact task with specific options to enable or disable the above three properties and then compact the database.
PropertyTabTo optimize performance/sizeImproves database performance?Reduces database size?
Allow use of stored forms in this databaseBasicsDeselect optionYesYes
Display images after loadingBasicsSelect optionYesNo
Don't maintain unread marksAdvancedSelect optionYesYes
Document table bitmap optimizationAdvancedSelect optionYesNo
Don't overwrite free spaceAdvancedSelect optionYesNo
Maintain LastAccessed propertyAdvancedDeselect optionYesNo
Don't support specialized response hierarchyAdvancedSelect the optionYesSlightly
Don't allow headline monitoringAdvancedSelect the optionPrevents performance degradationNo
Limit entries in $UpdatedBy fieldsAdvancedSelect the option and specify the number of entries $UpdatedBy fields can containYesYes
Limit entries in $Revisions fieldsAdvancedSelect the option and specify a limit on the number of entries $Revisions fields can contain. The suggested limit is 10 entries.YesYes

See Also