Speed Up Your Script By Using Getnextdocument



Download: IT Certifications 101
Inside this exclusive essential guide, our independent experts break down which IT certifications are worth your time and effort, and how to get started obtaining them to further your career— including specific certifications that any cloud or desktop pro should seriously consider.
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.
dealing with large numbers of documents, it is always more efficient to use
GetNextDocument. It is amazing how much faster the script will run using
GetNext rather than GetNth. Case in point: I used to run a script on several
thousand documents that took around 15 minutes to run. On occasion the script
would not finish because the server document had the Max Script execution time
set to 15 minutes. I went into the code and changed any instance of
GetNthDocument to GetNextDocument. That's the ONLY change I made to the
script. Since that change, it takes about 30 seconds to run! Wow. Throw the
GetNth out of your vocabulary, and ALWAYS use GetNext.
Dim session As New NotesSession
Set db = session.currentdatabase
Dim dc As NotesDocumentCollection
Dim doc As NotesDocument
Set dc = db.AllDocuments
Set doc = dc.GetFirstDocument
Dim count As Integer
count = dc.count
For i = 1 To dc.count
?Do whatever you need to do with the document
Set doc = dc.GetNextDocument(doc)
Next
'Watch your code scream through the docs!
Start the conversation
0 comments