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:

• Open a database and choose File - Application - Properties.
• As you create a new database, click the Advanced button.

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

• Don't maintain unread marks
• Document table bitmap optimization
• Don't support specialized response hierarchy
Tip You can use the Compact task with specific options to enable or disable the above three properties and then compact the database.

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
Document table bitmap optimization	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
Don't allow simple search Note This property also significantly improves system performance.	Advanced	Select the option	Yes	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

Database properties that optimize database performance

Glossary