Fix Performance Degradation with R5 Client

Having problems with DB views taking too long to open under the R5 Client when in R4 they opened immediately? By removing the "Maintain Unread Marks" property on the DB you can increase the perfomance significantly.

I had the problem of view taking 25 sec to open in r5.06a when they only took 1 sec in r4.67. The db I am opening is 888Mb with 100,000 docs so the views are quite large. The following is what I have done to improve the performance on the r5 client to be equal with R4. This may also help large mail files under r5 (if youre willing to remove Unread Marks).

This writes a log of events to the file. You can use this to find out which event is causing the time delays.

I opened the database from each client and compared the results.

The entry in question was
r4 client
OPEN_COLLECTION: RCV_UNREAD[175694] 1581 MS [240+191616=191856]
r5 client
OPEN_COLLECTION: RCV_UNREAD[212046] 23920 MS [240+212340=212580

RPC_NAME, Time

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Database LotusScript code rebuilds corrupted busytime.nsf file How to move Notes databases off Domino 8 servers and save disk space Top 10 Lotus Notes/Domino administration tips of 2008 Batch file runs scheduled Lotus Notes database maintenance tasks Fix and update Lotus Notes documents with limited access Programmatically replace the design of Lotus Notes databases Add a program doc to compact Lotus Notes databases automatically More efficient local Lotus Notes database replication Remove orphaned Lotus Notes documents on Domino databases with a 'virtual delete' Detect and fix 'Manager' access control list settings in Lotus Notes Domino

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

to complete, [bytes_sent+bytes_received=total]

This shows that the unread marks is causing r5 to take 24 seconds compared to 1.6 seconds in r5. So the obvious thing to do is to turn off Unread Marks in the Administrator, which by the looks of things has defaulted to Always On in R5. From the r5 Admin help, it seems that r5 ignores the view properties to Use Unread Marks and it is a Database property now????

In the Administrator, Open Server....select Files Tab, Select the DB.nsf, select Database | Advanced Properties, and Select (x2)"Dont Maintain Unread Marks". Hit OK

Help also specifies that you could also do it from the console
load compact paybillhrsbook2.nsf -u
-u is the setting for "dont maintain unread marks". (however this didnt work for me)

Close the Administrator and the Client I deleted the Cache.dsk file for good measure. Open the r5 client. Open the database. If it is a large db, it will take a fairly long time to open the db and reindex the views. Mine took a good 1/2 hour. But reindexing all from the client they now open in 1 sec.

Now in the log file the entry is
OPEN_COLLECTION: 9ms [68+34=102]

Notice that no mention of unread marks, and super fast.

Cheers
Ben