0.01 nanoseconds
Tim Tripcony
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.