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.
Code
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).
I put the following in the client notes.ini file.
r4
Client_Clock=1
Debug_Outfile=c:windowsdesktopr5tempdebug.txt
r5
Client_Clock=1
Debug_Outfile=c:windowsdesktopr4tempdebug.txt
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 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
