E
Estyn Edwards
I have a web-enabled Infopath 2007 form that has 9 data sources retrieving
data from an SQL2005 database. The largest source only retrieves 1300
entries and most retrieve around 50. The form is slow in response when
entering information into a field and then clicking on the next field
(approx 15 seconds to respond). The datasources populate drop down lists (2
are in repeating tables). When I have the datasource removed the form works
normally. However when I add the sources back again, the form works slowly
(even if I don't bind the sources to the drop down lists). The data sources
use a data connection library on my sharepoint site. The dropdown lists are
populated with data very quickly and i can use them right away, so it's not
the data that is taking to long, if i check with SQL Profiler the database
isn't being contacted after the initial load. Even if i wait a few minutes
after the form has loaded there is still a 15 second delay after i enter any
data into any fields.
Any thoughts?
data from an SQL2005 database. The largest source only retrieves 1300
entries and most retrieve around 50. The form is slow in response when
entering information into a field and then clicking on the next field
(approx 15 seconds to respond). The datasources populate drop down lists (2
are in repeating tables). When I have the datasource removed the form works
normally. However when I add the sources back again, the form works slowly
(even if I don't bind the sources to the drop down lists). The data sources
use a data connection library on my sharepoint site. The dropdown lists are
populated with data very quickly and i can use them right away, so it's not
the data that is taking to long, if i check with SQL Profiler the database
isn't being contacted after the initial load. Even if i wait a few minutes
after the form has loaded there is still a 15 second delay after i enter any
data into any fields.
Any thoughts?