https://www.infopathdev.com:443/forums/44.aspx enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/42755.aspxThu, 11 Jun 2009 10:51:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:42755ErnestoM0https://www.infopathdev.com:443/forums/thread/42755.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=42755<p>Hi Ada,</p> <p>I don&#39;t understand your question about SQL.&nbsp;However, the issue of large SharePoint lists is pretty common. Unfortunately, I don&#39;t know of an out-of-the-box solution for it. Some people opt for filtering. </p> <p>For example, say you have customer data. You create two dropdowns: Country and Customer Name. As the user fills out the form, they first select Country, which then filters the Customer Name dropdown to a more managable size. I don&#39;t know if this is possible in your data but it&#39;s a common option.</p> <p>The caveat: If you want to filter what is returned from the server, you will have to use a Web Service. SharePoint provides a bunch of Web services, but I&#39;m not sure if they allow filtering on a list, especially server-side. We do this a lot using our <a class="" href="http://www.qdabra.com/en/products/DBXL.aspx">Database Accelerator</a>. We filter the contents from SharePoint and/or SQL. </p> <p>If you want to filter client side, you can do this in InfoPath, but it means your form will still have to load all the records. In which case the performance of the form load will be affected.</p>https://www.infopathdev.com:443/forums/thread/42752.aspxThu, 11 Jun 2009 10:10:46 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:42752adayuen0https://www.infopathdev.com:443/forums/thread/42752.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=44&PostID=42752<p>Dear All,</p> <p>I have a data file which contains around 5500 records of user data. I created two data connections -one to very huge XML file and another to very huge SharePoint list. However both can&#39;t work in Browser form due to server timeout or what ever make the server can&#39;t response. Once I cut it 1/4 in size of records then it wokrs hence I guess this is due to too many records. </p> <p>I am wondering if there is anyway to connect to a single database file size @5500 records in browser-enabled InfoPath form? I don&#39;t have the SQL server. </p> <p>Please help!</p> <p>Regards,</p> <p>Ada</p>