Should I create 1 large view or multiple small views?

HCL Domino Domino Forum
1

Hi there!

I am wondering what is the best way to proceed in this scenario. I have a very large form where users can select to edit one area at a time. Each area must display an embedded view with appropriate columns showing. Should I create 1 view and hide all the extra columns or create multiple views and show only the appropriate columns. Just wondering how this would affect performance.

I should also mention that the view will hold approximately 1000 documents.

Thanks!

Gérald

2

Subject: Should I create 1 large view or multiple small views?

If you use thing effificently you have 1.7 million docs in a single view.

3

Subject: RE: Should I create 1 large view or multiple small views?

I am having a similar scenario as Gerald. I have a main form wich will have 10 embedded views (for displaying documents related to the first one). I need this much embedded views because i need to perform and show diverse calculations related to the documents contained by them.

I expect to have about 2000 documents composed with the “main” form. Each one of these will have about 10 - 25 “related” documents that will fall into the 10 embedded views.

Considering that the “related documents” all use the same form, what of the following would produce the best performance when it comes to refreshing the main document?:

  1. Create a single big cathegorized view wich contains all the documents and select them on each embedded view using the single cathegory property, or

  2. Create 10 different views with appropiate selection formulas and use each one of them on each embedded view?

Similarly i will be doing lookups to the related documents, and this need to be as fast as possible.

Thanks in advance for any tips anyone can provide.

4

Subject: Should I create 1 large view or multiple small views?

1000 documents is trivial. If you can make it fit properly, one view is fine.

5

Subject: Should I create 1 large view or multiple small views?

IMHO…1000 documents in a view is a pretty thin. Administratively, having 1 view with 1000 documents would be better then multiple views with 1000 documents. I am assuming that all of the 1000 docs are using that one form. If you can do it, I would go with the 1 view. However, if I was advising my developers, I would want to test the performance of the application with the 1 view and would be curious to see how things perform with multiple views. Other questions, how often will documents be added to the view(s)? If documents will be added or changed at a fast pace, having multiple views may cause some processing overhead on the server when views are updated.

.02