https://www.infopathdev.com:443/forums/40.aspxFor browser form specific questionsenCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/124523.aspxThu, 21 Oct 2021 10:05:18 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124523markikav0https://www.infopathdev.com:443/forums/thread/124523.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=124523Hi <br /> I think I have a way via a link Hilary sent previously in another post - https://wonderlaura.com/2011/08/01/infopath-query-specific-sharepoint-list-data/<br /> <br /> I have found that these methods always seem to work fine in the InfoPath client but once published to a browser form you don&#39;t know what might happen, especially from a performance perspective!<br />https://www.infopathdev.com:443/forums/thread/124520.aspxWed, 20 Oct 2021 09:31:00 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:124520markikav0https://www.infopathdev.com:443/forums/thread/124520.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=40&PostID=124520Hi InfoPath devs <br /> I&#39;m looking to optimise a data connection query in my form so I don&#39;t get slow load times or the critical error - default values or rules taking too long to evaluate, simplify the expression or reduce the size of the data sets that they depend on.<br /> <br /> I have a sharepoint browser form that uses multiple sharepoint lists as data sources, some of these lists had 200+ rows (about 4-5 columns) but now have grown to over 400+ rows and now I see the error.<br /> I did just let it load all data as the form loads and know this is not optimal so I removed that and put in a button to &quot;Get data&quot;.<br /> This works most of the time, sometimes it does time out, but it is very slow, so I assume there is something else I need to do to make it more efficient?<br />. <br /> This particular data connection I maintain a list of Service Lines plus Scenarios for those Service lines plus the template text response that applies to each scenario plus the audience each scenario applies to.<br /> example:<br /> Service Line = Account Closure<br /> Scenario = How To <br /> Template Text = IN order to proceed with......<br /> Audience = Customer<br /> Priority = 1 <br /> <br /> So Account Closure Service line would be stated 10 times in the list because it has 10 scenarios etc<br /> I pull this data into a request form as choices and once Service Line is selected this dictates the available scenarios, which auto populates the Template Text, Audience and Priority fields in the form.<br /> It all works fine then once the Service Lines are populated because selecting the scenario id filtered based on the Service Line selected.<br /> So i guess i need to just optimise the initial load for selecting the Service lines , there are about 30-40 Service Lines but the list has 400+ rows<br />. <br /> Any ideas?<br /> <br /> Thanks !