Hi,

In InfoPath preview mode everything is fine, data connection on the list of 15000 items is populating dropdown menu based on a filter(I am  only looking for two rows so filtering is implanted). Once published in Central Administration, form doesn't open -it is stuck at loading.

I have inherited development of this form and there is a connection to a similar list that works in an instance(both connection strings are searching for employees attributes). Is it possible that the data connection that doesn't effect the InfoPath performance contains parameters(filters in the connection string-since the filter are not implemented on InfoPath fields)?

My connection string is killing the performance of the form.

Please help me in querying filtered values in a large list(I am not saving a copy of the list in the form).

Nemanja

Hi ,

I have a following message from the browser

"script for this page is causing browser to run slowly"-this is caused by adition of data connection to the form.

Please help

Hi,

Please test the issue with connection to other SharePoint lists which has not that many records and check whether the InfoPath form stuck at loading.

If not, several ways you can try:

1. please link the data connection to a specific view in the list (not the default) which displays the require completed items.

2. You  could have a try to use Web service to get the external data if the data is from SharePoint list.

http://blogs.technet.com/b/anneste/archive/2011/11/02/how-to-create-an-infopath-form-to-auto-populate-data-in-sharepoint-2010.aspx

3. When you connect to the external data source (any business object), try to uncheck the option of loading the data on form load.

Several similar posts with the same issue for your reference:

https://social.msdn.microsoft.com/Forums/en-US/46553565-b66f-442c-8d11-8db469acb8d2/infopath-form-taking-long-time-to-load-data?forum=sharepointcustomizationlegacy

http://blog-sharepoint.blogspot.com/2009/08/infopath-performance-for-sharepoint.html

http://www.akspug.org/Blog/Post/99/Things-to-Check-when-an-InfoPath-Form-Takes-a-Long-Time-to-Load-in-Browser

Best Regards,

Dean Wang

Ok,

Here is the deal, there is a data connection to a similar list(not build by me in the same form), that loads instantaneously. The rules querying the list fields have no filter, yet it picks InfoPath users corresponding rows in the list.

How was this achieved. Again, there is no filter on the set filed value, just a reference to a list fiield-this looks like filter is a part of data connection. How was this done?

Nemanja

Hi,

We are currently looking into this issue and will give you an update as soon as possible.

Best Regards,

Dean Wang