HCLSoftware Business Partner
Domino Consulting Services
CRUCIAL Notes Tools
+1 212-599-2048

Domino Consulting Services
CRUCIAL Notes Tools
Domino administration
Notes development

Facebook Twitter YouTube
Chat now       
.
ProductsDownloadsNewsAbout usContact


Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

TUNING

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.

About this task

Make sure you fully understand these database properties before changing their settings.

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.
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, Optimize document table map, 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)
    • 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)
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.

    Note: You can use the Compact task with specific options to enable or disable the three properties and then compact the database.
    • Don't maintain unread marks
    • Optimize document table map
    • Don't support specialized response hierarchy
Related concepts
Access levels in the ACL

Related reference
Database properties that optimize database performance