Paul Galvin

Greetings,

I have an infopath 2007 form with 6 drop downs and as many as a dozen rules.

This form is a PO requisition form.

One of the drop-downs is wired to a sharepoint list containing vendor information.

The vendor list has 350 or so items.

It has columns like name, address, city, zip.

I have the rules set up such that when a user picks a vendor, other text fields on the form are updated with the address, city, etc.

When we run the form from the infopath 2007 client itself, performance is exactly what you'd expect and is very quick.

However, the browser form managed by MOSS is extremely slow. With just a few hundred vendors, it's taking nearly 20 seconds to select and then populate the address information.

It was very quick when there were just a few vendors.

What are my options for fixing this

Even clicking other drop downs with no associated rules is slow in the browser.

Thanks and regards,

--Paul Galvin




Re: SharePoint - InfoPath Forms Services Infopath 2007 // MOSS form services performance

JochenLeitner

go to the properties of the drop-down list --> browser forms and set the postback settings to never. this settings have improved the performance of my browser-based form.

Are you using Internet Explorer 6 or 7





Re: SharePoint - InfoPath Forms Services Infopath 2007 // MOSS form services performance

SYM Wong-A-Ton

Have you already seen this article http://msdn2.microsoft.com/en-us/library/bb380251.aspx It contains tips you can use to troubleshoot your form, although I think that your problem might be the large list and probably also bandwidth.



Re: SharePoint - InfoPath Forms Services Infopath 2007 // MOSS form services performance

Paul Galvin

I think it's IE 6. Do you think that would make a difference I will try and get IE7 installed.

Thanks.






Re: SharePoint - InfoPath Forms Services Infopath 2007 // MOSS form services performance

David Dean

The structure of your InfoPath form template can make a big difference in the performance of browser-based forms, because depending on how the sections and fields line up with the XML schema, InfoPath may have to post back a large amount of data.

Here are some tips that may help:

  1. Run the Design Checker using the "Verify on server" option and enable the performance messages. If it times out, you can use the "stsadm -o verifyformtemplate" command.
  2. Make sure you nest your section controls according to the structure of the XML schema. Improper nesting can cause Forms Services to greatly increase the amount of data it sends to and from the server.
  3. Eliminate all unnecessary columns from any secondary data source that is bound to a dropdown. Forms Services may otherwise bring all of this data down to the client even though it isn't displayed. You may have to use two separate data source, one being just a list of vendor codes and names, and the second returning all details for a single vendor based on its vendor code.
  4. Given the number of vendors you may want to use an alternative mechanism other than a dropdown for selecting the vendor. One possibility would be to add another view to your form template that provides a search criteria text box and a repeating table to show the list of vendors. On each row, include a Select button that sets the vendor information and then returns to the main view. Then add a button to the main form that switches to the Select Vendor view.






Re: SharePoint - InfoPath Forms Services Infopath 2007 // MOSS form services performance

Paul Galvin

#4 sounds very interesting and I wish I had thought of that at the time. I've moved on to other projects, but I blogged my solution to it here: http://paulgalvin.spaces.live.com/blog/cns!1CC1EDB3DAA9B8AA!125.entry

Thanks for the feedback and next time, I'll try that approach.

--Paul Galvin






Re: SharePoint - InfoPath Forms Services Infopath 2007 // MOSS form services performance

VenuBonala

I have a repeating table with rich textboxes inside.As I keep insert a new row data the performance degrades. I think it is because of using richtextbox in combination with Repeating table. But is there any update or way to improve the infopath performance on browser.