I am currently connecting to a SQL Server successfully with InfoPath 2010, but I'm connecting to a table that has over 90,000 entries. In my InfoPath form I only require 1 line item (5 values from the line item to be exact, 1x5) to be returned, but have discovered that InfoPath wants to store all 90,000+ items in memory (90,000x5) THEN ...