Page tree
Skip to end of metadata
Go to start of metadata

You can reference the original article submitted by John Jardin.

Quick Summary

Enabling "Optimize Document Table Map" improves the way Notes views are indexed and built in a Notes Database.

To enable this setting:

  1. Right-click on your Notes database and select "Application -> Properties"
  2. Click on the last tab
  3. Check the option "Optimize Document Table Map"
  4. Compact the Notes database

NOTE: Ensure that each of your Notes views in the database reference the Form field in the view selection formula.

i.e. Select Form = "FormA"

Detailed Overview

There is a very important setting for a Notes Database that's not enabled by default, but when enabled, drastically reduces the time required to index and build Notes Views. It's called "Optimize Document Table Map".

When updating a view in your Notes Database, Domino refers to tables of document information. These tables will contain information from documents that were created by each form that exists inside your Notes Database. With "Optimize Document Table Map" disabled, during view updates and rebuilds, Domino searches each table for documents appearing in the view being updated. With "Optimize Document Table Map" enabled, tables are associated with the forms used by the documents the tables contain. This means the during view updates and rebuilds, Domino only searches tables associated with the forms used in the View being updated.

Scenario

Let's say you have a Notes Database that contains about 5 different forms. For each form you have about 5 Notes Views. Also for each form you have about 10000 documents.

If "Optimize Document Table Map" is Disabled

If View1 is being updated, and contains documents created by FormA, the following occurs: 

  • Domino searches tables associated with every view in the Notes Database (25 tables in this case), to collect documents created by FormA that need to be displayed in the View1 being updated
  • If you only have a few hundred documents in the database, this would not really be an issue.
  • However, 50 000 documents later this could lead to poor performance.


If "Optimize Document Table Map" is Enabled

If View1 is being updated, and contains documents created by FormA, the following occurs: 

  • Domino only searches tables that are associated with documents that were created using FormA (5 tables in this case)

 

 

Important Notes

  • For every view in your Notes Database, ensure that that the selection formula includes a reference to the Form field:
    • e.g. Select Form = "FormA"
  • When this setting is changed, you have to perform a Compact on the relevant Notes Database for the change to take effect.


Step-by-step guide

  • Right-click on your Notes Database and go to the "Database Properties"
  • Click on the last Tab
  • Check the option "Optimize Document Table Map"

  • Compact the Database (You might need an admin to help you with this)