https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/79814.aspxMon, 25 Jun 2012 12:30:20 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79814ErnestoM0https://www.infopathdev.com:443/forums/thread/79814.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=79814<p>For a list with 1700 items, you will face a delay on load. The only option that comes to mind is to somehow create a cascading filter. For example, let&#39;s say the items are divided into Categories. The user would first select a category in the IP form. Based on the selected Category, then the second dropdown will show the list items that match that category. So instead of 1700 items in one dropdown you would be retrieving perhaps 250 items, producing a performance improvement.</p><p>Good luck! <br /></p>https://www.infopathdev.com:443/forums/thread/79808.aspxMon, 25 Jun 2012 03:05:30 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:79808mn_laaziz0https://www.infopathdev.com:443/forums/thread/79808.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=79808I am loading a Sharepoint list to a Dropdown control through a data connection, it is working fine, but it takes about 5 minutes to load the form in the web because the list is very long ( about 1700 entries) Is there any way to do the same thing in a very fast way?