Hi All,

 

We have a database (no XPage components) with a lot of documents (500,000 +) , each with a read-access names field to control which user can see them and which can't.  There is then a second database (XPages) which the user logs into that acts as a front end.  This is via a web browser, not a notes client.  The XPage I'll be referring to here has a view control which points to the data DB and a view that has all 500k documents categorized.

 

When the user loads the XPage that references to this all documents categorized view, they have to wait 2 minutes for the view control to read this data back.  If I remove the read-access names from all the 500k documents the loading time drops from 2 mins to 5 seconds!  I understand the waiting time is going to be longer with read-access names than without it (as it has to check every single document when a user access the view to determine what they can and can't see), but is there anything I can change so I can improve the 2 mins loading time without removing the read-access names fields?

 

Thanks in advance!