Why would 1.000 subforms in a db be a bad idea?
Posted
by KlaymenDK
on Stack Overflow
See other posts from Stack Overflow
or by KlaymenDK
Published on 2010-06-17T16:16:28Z
Indexed on
2010/06/17
16:23 UTC
Read the original article
Hit count: 172
Performance
|lotus-notes
Warm-up
I'm trying to come up with a good way to implement customized document forms.
It's for a tool to request access to applications; each application will want to ask its own specific questions. The thing is, we have one kind of (common) user who needs to fill in and submit documents based on templates, and another kind of (super) user who needs to be able to define what each template needs to contain.
One implementation option would be to use a form (with the basic mandatory stuff), and have that form dynamically include a subform appropriate to the specific task at hand. The gist of the matter is that we could (=will!) quite easily end up having many hundreds of different subforms!
(NB. These subforms will be maintained in an automated manner, but that is another topic that may be considered outside the scope of this Question.)
Question
It's common knowledge that having a lot of views in a Notes database is Bad Thing. But has anyone tried pushing the number of forms or subforms and made any experiences regarding performance?
© Stack Overflow or respective owner