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.

Before you begin

Make sure you fully understand these database properties before changing their settings. For information, see Database properties that optimize database performanceProperly setting database properties can improve the performance of an active database. Setting database performance properties on many databases or on one, large, active database can also improve server performance. In addition, some of these property settings also help reduce the size of databases. Many of these properties require knowledge of application design, and the database designer often sets these properties when creating a database..

Procedure

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

2. Do one of the following:

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

Note: In the following steps, properties with an asterisk (*) improve performance but do not reduce database size.

• Display images after loading (Basics tab)*
• Don't maintain unread marks (Advanced tab)
• Optimize document table map (Advanced tab)*
• Don't overwrite free space (Advanced tab)*
• Don't support specialized response hierarchy (Advanced tab)
• Don't allow headline monitoring (Advanced tab)*
• Don't allow simple search (Advanced tab)*
• Limit entries in $UpdatedBy fields (Advanced tab)
• Limit entries in $Revisions fields (Advanced tab)
• Compress database design (Advanced tab)
• Compress document data (Advanced tab)
• Use Domino® Attachment and Object Service (Advanced tab)

• Allow use of stored forms in this database (Basics tab)
• Maintain LastAccessed property (Basics tab)*

• Don't maintain unread marks
• Optimize document table map
• Don't support specialized response hierarchy
• Use Domino Attachment and Object Service (Advanced tab)
• Move views out of database

Note: You can use the Compact task with specific options to enable or disable the properties and then compact the database.

Related reference
Database properties that optimize database performance