Data Connections

Re: Form grinds to a halt after database look-up

Jimmy — Mon, 27 Oct 2008 14:52:10 GMT

I can't be sure, but it sounds like the form is running slowly because it is weeding through the entire 5000 row table in your secondary DOM when the rule is run. You may want to consider instead running an SQL query to get the employee you want, and not store the whole table in your secondary DOM.

For examples of how to do this, please see:
http://www.infopathdev.com/forums/p/9467/33496.aspx#33496
and
http://www.infopathdev.com/forums/p/8940/31780.aspx#31780

Re: Form grinds to a halt after database look-up

dprice_2000 — Mon, 27 Oct 2008 13:41:45 GMT

Hi Jimmy,

The rule is as follows:

xdXDocument:GetDOM("Colleague_Information")/dfs:myFields/dfs:dataFields/d:Colleague_Information/@last_name[../@employee_number = current()]

There is no other code involved.

thanks,

Dave

Re: Form grinds to a halt after database look-up

Jimmy — Sat, 25 Oct 2008 01:18:51 GMT

Are you querying the entire table every time? If so, the form is probably running slowly because you have so much data in its DOM.

Perhaps you could consider querying only a portion of the table as necessary.

Form grinds to a halt after database look-up

dprice_2000 — Fri, 24 Oct 2008 19:37:44 GMT

Hi All,

I have a form on which a user enters an employee number and a query brings back corresponding payroll information.
The data resides in a single SQL Server table of about 5000 rows. There are no indexes.
I have created rules on the employee number field to look up the information using a secondary data source.
The secondary data source is part of the form and not on a sharepoint site.

After I enter the employee number it brings back the information correctly, but form grinds to a halt.
Moving from field to field is in slow-motion.
When I submit the form, I get the following error:

Stop running this script?

A script on this page is causing Internet Explorer to run slowly.

If it continues to run, your computer may become unresponsive.

Y/N

Any ideas?

Thanks,
Dave