Performance when opening a form

[E]

We have built a Requisition Form.
1: I am trying to understand if the speeds we are experiencing are normal.
2: How can we speed it up at our remote locations?
3: Does Forms Server reduce the initial opening time?

We use data connections to SQL2005 and other Sharepoint Lists. Maybe 10
lists?

When opening a new or existing form it takes 10 seconds.
In our remote plant with T1 connections it always 35 seconds to open a new
or existing form.

emk

 

[Bryan Phillips]

Do you have any code in the code behind? Is the form a browser-based
form? If it is browser-based, is the performance the same using IE
versus Firefox?

Also, check my blog for several workarounds for pitfalls when using
Forms Service.

--
Bryan Phillips
MCT, MCSD, MCDBA, MCSE
Microsoft MVP - Client Application Development
Blog: http://bphillips76.spaces.live.com
Web Site: http://www.composablesystems.net

 

[SSA]

Yes, as Bryan mentioned, check your form in firefox. Performance of web
enabled forms in firefox is much better than the IE. This is because IE uses
strict parsing rules and the form loads and works very slow. Also try IE 7
which is better in performance than IE 6. Here are some more recommendations:

1. If your form is very large, break it into smaller sections using views.
2. Explicitly close any data connections opened in your code.
3. Avoid unnecessary loops
4. Use xsl queries to find an xml node instead of using loops.
5. Use fiddler or IE developer tool bar to find any hidden script errors in
your form