Set Database Properties to Improve Database Performance

By default, newly created databases are not optimized for performance. This is especially true when you create databases designed for Web clients. Therefore, you must modify some settings to improve database performance and reduce database size. Specifically, various settings on the Advanced Options tab of the database Infobox help improve database performance.

The database properties are described in detail in “Setting Database Properties,” in Chapter 2, “Database Management.”


The following sections outline settings that can be manipulated to improve performance.

Basic and Advanced Database Settings

Table 7.1 outlines database settings available on the Basics tab of the Database Infobox, and Table 7.2 outlines specific database settings, located on the Advanced tab of the Database Infobox, which help improve performance.

Table 7.1. Basic Database Options
Dialog Box SelectionDescription
Allow Use of Stored Forms in This DatabaseEnabling this option increases disk space and decreases application performance. Although storing the design of a form in a document ensures the document always displays with the specific form design, it can increase the disk space up to 20 times the original size.
Display Images After LoadingEnabling this option improves database performance. As the setting implies, when selected, all text on a form is loaded prior to the images. Therefore, users can read the text while larger, slower images are loaded. If this setting is not selected, images are loaded in conjunction with text as they appear in the document. This setting only affects Notes client users.

Table 7.2. Advanced Database Options
Dialog Box SelectionDescription
Unread Mark Options: Don't Maintain Unread MarksSome databases may not need to track unread documents, and disabling this feature increases performance and reduces database size. You can also disable views from displaying unread marks, but this results in no performance improvement. The database must be compacted for this setting to take effect.
Advanced Option: Optimize Document Table MapUsing only the forms referenced by the documents contained within each view, this option associates only the tables using the document forms to update each respective view, thus increasing performance. Internally, Domino maintains tables containing information about documents contained within each view. These tables are used when the view indexes are updated or rebuilt. If the views contain selection formulas that specify which forms to use (for example Form=“Main Document”, enabling Document Table Bitmap Optimization optimizes performance by using only the tables that use the forms specified in the view selection formula.
Don't Overwrite Free SpaceAs a security feature, Domino automatically overwrites deleted data with new data, ensuring that deleted data cannot be recovered. This causes additional I/O operations to the disk. Selecting this option increases performance, but alternative security options should be considered.
Maintain LastAccessed PropertyWhen enabled, Domino tracks who last read the document. Disabling this option causes Domino to track only who last modified each document, thus minimizing disk I/O operations and increasing performance.
Disable Transaction LoggingAfter transaction logging has been set up, all database transactions are logged. Disabling this feature by making this selection increases performance but is generally discouraged because it makes it more difficult to recover from system failures. This is the better option to use on non-critical databases such as help databases or databases in which the data doesn't change very often.
Don't Support Specialized Response HierarchyDisabling this feature reduces the information stored to support certain @Functions used in views to display response documents (specifically, the @AllChildren and @AllDescendants functions). Therefore, this setting improves application performance and slightly reduces the database size. Views and replication formulas that do not use these two functions still display response documents as intended. The database must be compacted for this setting to take affect.
Use LZ1 Compression for AttachmentsThe new enhanced compression method available with Domino 6. This increases the performance when downloaded, uploaded, or opening attachments. When enabled, Domino uses LZ1 compression.
Don't Allow Headline MonitoringWhen selected, prevents users from using headline monitoring for the database. Restricting the user of headline monitoring improves performance.
Soft Delete Expire Time in HoursSoft deletions allow for deleted documents to be held in the database for the specified amount of time before being deleted. Reducing the time deleted documents are held minimizes database size and helps improve performance.
Limit Entries in $UpdatedBy FieldsEnables you to limit the number of entries in the $UpdatedBy field. This field contains the canonical name of each person or server who has edited the Notes document. If each document has a lot of activity and many modifications, reducing the number of revisions tracked per document can increase performance and reduce database size. When the limit is reached, the oldest entry is removed.
Limit Entries in $Revisions FieldsEnables you to limit the number of entries in the $Revisions field, thus increasing application performance and reducing database size. This field contains the date and time each Notes document was edited. If each document has a lot of activity and many modifications, reducing the number of revisions tracked per document can increase performance. When the limit is reached, the oldest entry is removed. By default, this field contains up to 500 entries. Because each entry requires 8 bytes of disk space, the larger this field becomes, the slower the database performance. Because this field is used to resolve replication or save conflicts, this value should never be set to less than 10.

Other Options for Optimizing Database Performance

In addition to modifying database properties, the following options can help you optimize database performance

  • Upgrade the database to Release 6 (which uses a new, optimized On Disk Structure).

  • Enable transaction-based logging and recovery.

  • Compact the databases.

  • Set database size quotas.

  • Delete or archive inactive documents.

  • Modify the replication formula to limit the size of the database by replicating only required documents.

  • Modify the database purge interval to remove deletion stubs more frequently.

  • Disable soft deletions.

  • Disable default user activity recording.

  • Customizing Advanced settings and file system settings that optimize disk space usage and reallocation.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.144.237.122