Domino document/entry collection limit?
I've heard that there is a problem with processing document (or entry?) collections, even walking a view, if the number of documents or entries is greater than about 1000. Is this true, and if so, why and what can I do to get around this limitation? Thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
March 19, 2009 2:05 PM
UPDATED:
March 20, 2009 2:14 PM
Answer Wiki:
I'm sorry, I forgot to mention that I'm using Domino 7, and the question applies to both Java and LotusScript. Thanks.
To see all answers submitted to the Answer Wiki: View Answer History.
are you talking about NotesDocumentCollection greater > 1000 documents ?
I never had any problems with that, even in Domino 7 !
But if it would be the case, i suggest you use the NotesViewEntryCollection, wich is a better way for a memory performance point of view and avoid Get
There is no problem with looping very, very large collections. The problem that may have been refered to is GetNthDocument. That method is inappropriate for looping. I don’t even know when GetNthDocument would be appropriate to use. I supposed if you knew that a collection was ordered a certain way and you wanted to get the 50,000th document in the collection, then it would be appropriate. But there would probably be a more efficient way to do that (documentbykey in a view, or something).
From Help: Using GetNthDocument to iterate through a loop is strongly discouraged for performance reasons. See GetDocument, GetFirstDocument, GetLastDocument, GetNextDocument, and GetPrevDocument for the preferred loop structure.