In this section, we look into two database properties of particular interest to performance Unread Marks and Optimize Document Table Map.
In real-world installations, there is a substantial penalty in large databases for having Unread Marks enabled. So if your application doesn't use them, turn this feature off at the database level. To do this, open the database and select File|Database|Properties, then open the last (beanie) tab, and select the Don't maintain unread marks option.
Following is an example (somewhat cleaned up for easier reading) of the output you might see if you ran your client debugger while opening a database:
GET_UNREAD_NOTE_TABLE: 600 ms OPEN_COLLECTION(REP85256055:004781F8-NTFFFF0020,0040,0000) OPEN_DB(CN=HQ/OU=Boston/O=Acme!!Applications\SalesTracking.nsf): (Connect to HQ/Boston/Acme: 5000 ms) GET_UNREAD_NOTE_TABLE: 4000 ms RCV_UNREAD 2000 ms
All the preceding lines appear if Unread Marks is enabled. However, only the highlighted lines...