Max # of Views

Does anyone know what the most recent limitations are on the number of views allowed in a database?

I remember there used to be a ~250 limit but I’ve seen applications with twice that number - that seem to work just fine.

I’m on 6.5 right now… Will it change for 7 + ?

TIA

Subject: Max # of Views

There was a practical limitation in 4.5 of about 440 folders/views - this was due to memory allocation on the domino side that was filling up when trying to replicate. We overcame it at that time by increasing some variable I don’t remember in the notes.ini. We have functioning databases in 6.5 with 700+ - I don’t know what the actual limit is though.

Subject: Thanks!!

Thanks Siri, that was great info.

Subject: Thanks To Everyone!

I appreciate all your responses.

JA

Subject: Max # of Views

I’ve never known of a limit on the number of views, but I can tell you that the indexer will get cranky as you increase the number.

regards,

raphael

Subject: RE: Max # of Views

I thought there was a limit on the number of views - (maybe back in the 3 or 4 days)

The 6.5 help says exactly what you say - No limit - but performance decreases as the quantity increases.

It also says a limit of 200 ‘cascading views’

Maybe that’s what I was thinking about…

Thanks Much!

Subject: RE: Max # of Views

Just FYI: here’s a helpful reference

Subject: RE: Max # of Views

that’s a great reference.Thanks Wing

Subject: RE: Max # of Views

Dear,

Why are you creating +200 views?

Can’t you do the following?

Create a search page, where a user can fill in some values, and generate a HTML table (view) which is shown in a document?

This also works in client

Subject: RE: Max # of Views

hehe - funny you mention thatI’ve already done one of those - but -

everyone always wants a specific layout of some kind!

Thanks for the advice

Subject: RE: Max # of Views

So allow modifications and tech them how to remove columns and slide them around. I realize you’ll always have some need for custom views, but 200+ just sounds like a disaster waiting to happen :wink:

One thing you could do is put a bit of code in each view post open that collect who opened the view and when. Store the results in a separate db. Then wait. Over time, you’ll collect a list of views that actually get used. You should be able to then go back to your user community and tell 'em that 150 of the views get used once in a blue moon and they’re going bye-bye.

(I think that the 6x admin client acutally collects some of this data so don’t code it up until you’re sure it’s needed).

Good luck!

Doug

Subject: RE: Max # of Views

sounds like some great advice. Thanks Doug