InfoPath Dev

I am new to infopath but have been able to succefully create a number of forms attaching to my SQL server 2005 database. I have a number of fields that utlize dropdown boxes that require that data be looked up in other SQL server 2005 tables.  (4-5 different look ups).   All of these are lookups only and the data is then used to populate fields in the MAIN data source.  This all works fine except if I add a dropdown box on one dataset that happens to contain 25,000 records.  (authors names).  The data is indexed yet opening the form is very slow and my queries on the main data source take FOREVER.... Updates and adds take even longer...     Any hints on setting this up better to drastically improve performance...?

Thanks

Scott Haigh 

Hey Scott,

This is another great use of the Database Accelerator EnumDB web service since you can use an actual query to limit the data returned instead of having to load the whole table.

How To - Sort and Filter Database Results with DatabaseEnumerationService Query Database Using XML Filters (EnumBD)

Hi

I output the tables as .XML then natively add them to the form that way the form is opens the datasource when opened so it is a lot quicker.

Filtering is a very good solution if applicable though.

Cheers