SharePoint Development & Administration + InfoPath

InfoPath provides a rich set of capabilities for integrating with SharePoint.  This includes the ability to easily configure data connections to retrieve or submit data to SharePoint without the use of code.  When the lists and libraries being queried from InfoPath become large, the InfoPath form can become slow when working with the results from data connections.  This is more apparent if the form is being displayed in a browser using InfoPath Form Services, at the results of the query must be rendered into HTML, sent to the client and updated in the browser. Many of the solutions that I have built in the past required variation to the process depending on if data exists in SharePoint, or if the data falls within specific ranges or explicit values.  To do this, code was used to loop through the results of the secondary data sources to find the required records.  This can become slow very quickly once there are a large number of documents of items in the Share...