https://www.infopathdev.com:443/forums/47.aspxFor questions concerning issues in the integration of SQL and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/17291.aspxSun, 11 Jun 2006 03:09:54 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17291Matt Faus0https://www.infopathdev.com:443/forums/thread/17291.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17291You should be using a database query filter, not a InfoPath data filter. To filter in the query string, check out this HowTo:<a target="_blank" href=http://www.infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353>http://www.infopathdev.com/howto/tutorials/default.aspx?i=0bb37b4de44348408680a53a449f2353</a> or this post:<a target="_blank" href=http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2561>http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=2561</a><br /><br />As I've been working on and using the EnumDB web service I must say that it is the king of performance. The web service has physical access to the DB on the server-side and then serializing to XML and streaming it down is much faster! You also don't have to deal with permissions and all the extra overhead.https://www.infopathdev.com:443/forums/thread/17290.aspxSat, 10 Jun 2006 08:27:12 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:17290Patrick Halstead0https://www.infopathdev.com:443/forums/thread/17290.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=17290Hi JSchweg and welcome to our forum,<br />We have a solution for you. We are adding a new EnumDB web method to the next release of our Database Accelerator suite that will support filtering within the query using data fields.https://www.infopathdev.com:443/forums/thread/16814.aspxTue, 06 Jun 2006 19:54:55 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:16814jschweg0https://www.infopathdev.com:443/forums/thread/16814.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=47&PostID=16814I'm new to InfoPath, but have sucessfully figured out how to link controls to various SQL tables, filter the data, ect.<br /><br />The problem is that is seems way to slow. Some of the database tables that I'm displaying are fairly large, however I'm only displaying certain values based of other fields with my filter logic. The problem is that InfoPath seems to need to read ALL the data in and then filter it afterwards, which makes the form painful.<br /><br />I'm new to this, so I'm sure that I'm just doing something dumb, can someone offer some advice?