How many nos. of documents a column of a view can hold?

HCL Domino Domino Forum
1

how many nos. of documents a column of a view can hold?

2

Subject: how many nos. of documents a column of a view can hold?

I don’t think their is any limitation for a view.You can search “table and notes and limit” in designer help for limitations

3

Subject: RE: how many nos. of documents a column of a view can hold?

You have limitations on columns in a view.If i remember correct you can only use 110 columns in a row…

4

Subject: Performance will probably be the first limit . . .

Notes Views can easily hold hundreds of thousands of documents, but unless you have really powerful hardware, the usability of such Views can degrade to make them unusable well before you hit any technical limitation - The design of your View can have a huge impact on how quickly it can be indexed and be opened. A few tips I always work to:

  1. Avoid lots of categorised columns. Also, go easy on how many sorted columns you have and which have “click on column header to sort” enabled.

  2. Avoid columns that perform complex calculations on data - Try to pre-compute values on the document (e.g. through the Form or with scheduled Agents).

  3. Avoid columns that display lots of data e.g. full postal addresses, contents of a comments field etc.

  4. Do not use “@Now” in View selection or column formula e.g. you might be tempted to use it to dynamically calculate if something is overdue. @Now might appear fine with a test data set of a few 100 or 1000 documents, but your View’s performance will degrade exponentially when more documents are added.

There are some Redbooks about Notes application performance that go further, go have a search . . .

Hth.

James.

5

Subject: RE: Performance will probably be the first limit . . .

Hi,

Search a little bit :wink:

Date

Topic

RE: Towards the end of view refresh, client will be locked first (JY Riverin)

RE: Performance with readers fields (JY Riverin)

RE: Performance Problem (JY Riverin)

RE: Opening a DB SLOW for some (Jean-Yves Riverin)

RE: My plan to reduce view index rebuild time (JY Riverin)

RE: Measuring application performance in Domino Administrator 6 (JY Riverin)

RE: Knowledge Collection: Read and Unread Marks in Notes/Domino (JY Riverin)

RE: Design of a DB with readers… which is the best design? (Jean-Yves Riverin)

JYR

For faster answers, be C R I S P Y