The form opens really slowly for editing. I've got all the appropriate
indexes on my tables. Is there a way to spead up the load process or have it
load in the background?
Here are some options.
For your secondary data connections limit the columns to just the data
fields you are using. You may need multiple data connections to the same
table and each grabs a different amount of columns. Do not waste resources
on loading all the fields at form open.
Sometimes it is better to not have them load automatically and only load
them as you need. Maybe have the DC for the initial dropdown load
automatically and then use rule actions to query the next one needed after
the first dropdown selection, etc.
Best practice is to use web services for your data connections. They are
more efficient and you can query the tables so you do not have to load all of
the data in the table. You can check out the Database Accelerator download at
The Largest InfoPath Forum in the World
On Dec 14, 12:29 pm, Lee Vance <LeeVa...@discussions.microsoft.com>