Tip of the Iceberg

Category lotusscript
Ever since Peter von Stöckel posted about using NotesDatabase.GetProfileDocCollection to quickly create an empty NotesDocumentCollection, I've been meaning to benchmark it against a database with hundreds of thousands of documents, but keep forgetting to. Earlier tonight I had a reason for needing an empty collection, was reminded of the benchmarks Nick Wall provided on Peter's post (tested on a Domino 6.5.3 server), and realized that my web server log would be an ideal candidate to see if the speeds are similar in the Notes 8 client... at the time, it contained 541,269 documents. Here's how it turned out:

	db.Search ({@False}, Nothing, 0)	db.Search ({@False}, datTomorrow, 0)	db.GetProfileDocCollection ("EmptyCollection")
1	3.074	0.191	0.04
2	3.295	0.201	0
3	3.104	0.201	0
4	3.125	0.2	0
5	3.054	0.201	0
6	3.205	0.19	0.01
7	3.084	0.2	0.01
8	3.115	0.2	0
9	3.094	0.2	0
10	3.225	0.2	0
Average (in seconds)	3.1375	0.1984	0.006
Per document (in nanoseconds)	5.9765	0.3665	0.011

Still scales pretty well. Let me know if you've done any benchmarking against a huge database that also contains a significant number of profiles... my DomLog only contains one.

(cross-posted at BleedYellow)