Large Lotus Notes Form

HCL Domino Domino Forum
1

I have a form in production that contains over 20 subforms and many, many fields. All but three or four of the subforms are hidden at any given time depending on products used on the job.

Most of my fields are checkboxes or editable fields or computed text fields – not many dblookups at all.

The problem is, when I open the form, there is maybe a 3-4 second delay. But for one of my users it takes about 20 seconds for the form to open on her workspace. You might think that the most logical reason would be the difference in our computers, but we are using identical systems and we are both on the same internal server.

One thing I thought would help would be to utilize shared fields where I could. But my biggest problem is I am unable to split the form into multiple forms, which is why I decided to use subforms instead.

If anyone has any suggestions on how I might be able to reduce the overhead on this form I would appreciate any suggestions.

2

Subject: Large Lotus Notes Form

Hi Lisa,

assuming you are using computed subforms, you need to reduce the number ob subforms loaded with the main form at the same time.

When opening a form with computed subforms, notes checks every field in the subform against every field in the main form and in the already loaded subforms. As you said you have many fields per subform, this kills every machine.

So make shure, that you always load as less subforms as you need.

hope this helps Stephan