Get the most from Notes®

The view doesn’t open the document, but the collection does! View vs collection can be very bad if you are not being careful.

In the first two instances John was using a view to get the documents and then using the document that was returned to get the form name, but since the calls are the same for collections and views, it’s easy to just swap out one for the other without having to change too much other code. In a real world scenario, the opening of the collection or view may even be done somewhere else. Here, because the view apparently doesn’t open the document like the collection does, to the first call to actually get something off the document needs to do the open.

Now in this case the overall performance of the view is probably 2x slower than the collection since the collection only opens the documents once, but here, each loop opens the all the documents. John claims that GetNth and getNext are equivalent, and he is right, but he also says he wouldn’t recode his loops, either, but I say he missed the bigger problem – what he was doing IN the loops.

This is real benefit in using a performance monitoring tool like Profiler. Sometimes you find things you were not looking for that end up being the real problem… like with everything else in life it’s always in the last place you look.