- Lotus Notes/Domino 7 application performance: Part 1: Database properties and document collections
- Lotus Notes/Domino 7 application performance: Part 2: Optimizing database views
The biggest "performance killers" in terms of view indexing are categorized columns. Sort columns add a small amount of overhead as do some other features, such as the Generate unique keys option.There are two accompanying charts that reinforce this statement. The first one displays View index size versus response times and we see that the categorized views (the two rightmost bars) having index sizes considerably larger than those of comparable non-categorized views:
Here's a typical view, the Database Activity by Action / User view (shown with the new navigator coming in NotesTracker Version 5.0):
One user of NotesTracker has reported that it only took around 55,000 usage log documents for their NotesTracker Repository database to reach a size of 1 GB, so you may see a need to somehow minimize the database's size.
In light of the findings about categorized views described in the articles, if you feel that you want to reduce the size of any of your NotesTracker Repositories, one good way way to do so would seem to be by deleting unwanted and/or infrequently-used categorized views from the repository's database design. (You could might gain some advantage by implementing some of the other techniques described in the two articles.)
We would be very interested in recieving your feedback if you try doing any of this.