Form Slow to Start Up

[John Sivilla]

I am having a performance issue with a form which takes up to a minute to
open. In an effort to isolate the problem, I deleted each control, data
connection, field etc one by one, but even when I have practically nothing
left on the form, the performance issue still persists.
At this point I suspect it has something to do with a misaligned data
connection or field or something of the like.

What should I check or do to solve this problem?

thanks,

 

[Franck Dauché]

Hi John,

Do you have code behind your forms? If you do, large number of Event
handlers can slow down your form... a lot. Do you have code in the OnLoad
event?
How big is your schema? Are you using Managed Code or Scripting behind your
form?

Franck Dauché

 

[John Sivilla]

Hi Franck,

Thanks for responding.

This is the strange thing about this. I have only two methods of scripting
code, everything else are rules. I have no code in the OnLoad event and my
schema contains about 30 to 40 fields. I also have three secondary data
sources. The only thing I could think of which is out of the norm is that I
have a large number of roles (9 in all). Does this cause a problem?

I think I don't know enough about what InfoPath does when it starts up.

Thanks for your help,

 

[Franck Dauché]

Ok, if you have your fields on one single View with a large number of Rules
and/or Conditional formatting, performance will go down...fast.
Here are some ideas:
1. Your data connections can be the problem, as IP is retrieving data each
time the form opens up. Try to create another form with the same
connections, but uncheck the "Automatically retrieve data when form is
opened" checkbox. See if that helps.
2. If you can, split your Main View into several Views (if you didn't do
that already).
3. If you can, push some of your business logic into code behind, it will be
faster.
If you can, you may want to handle OnBeforeChange and OnAfterChange event at
the FORM level, not for each control (else performance issue will just be
moved, not solved). In there you can implement there the logic you need.

Franck Dauché

 

[willib]

Hello

problems during startup of infopathforms
may be caused by a different setting of spellchecking languages.
in infopath the spellchecker can be set on form and fieldlevel.
you may gain speed by turning the spellcheck off.

hth
willib