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?
Thanks,
Lee
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
http://www.qdabra.com
--
Thanks
Clay Fox
Qdabra Software
http://www.qdabra.com
InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com
HTH
On Dec 14, 12:29 pm, Lee Vance <LeeVa...@discussions.microsoft.com>
wrote: