Lotus Domino Administrator 8.5 Help - Setting database properties that optimize database performance

PERFORMANCE

Setting 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.

2. Do one of the following:

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

3. Enable as many as possible of the following properties:

Note

Of the following properties, these improve performance but do not reduce database size: Display images after loading, Document table bitmap optimization, Don't overwrite free space, Maintain LastAccessed property, Don't allow headline monitoring, and Don't allow simple search.

Display images after loading (Basics tab)
Don't maintain unread marks (Advanced tab)
Document table bitmap optimization (Advanced tab)
Don't overwrite free space (Advanced tab)
Don't support specialized response hierarchy (Advanced tab)

This option only slightly reduces database size.

Don't allow headline monitoring (Advanced tab)

This option does not improve performance but prevents performance degradation.

Don't allow simple search (Advanced tab)

This property also significantly improves system performance.

Limit entries in $UpdatedBy fields (Advanced tab)

Also specify the number of entries $UpdatedBy fields can contain.

Limit entries in $Revisions fields (Advanced tab)

Also specify a limit on the number of entries $Revisions fields can contain. The suggested limit is 10 entries.

Compress database design (Advanced tab)
Compress document data (Advanced tab)
Use Domino Attachment and Object Service (Advanced tab)

Also make sure "Disable transaction logging" is not selected.

4. Disable as many as possible of the following properties:

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

5. After you select any of the following 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.

Related topics

Access levels in the ACL

Database properties that optimize database performance

Feedback on Help or Product Usability?

Help on Help

All Help Contents