Drop down list box too slow when selecting an entry

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mzam - 06 Nov 2007 10:19 GMT

Hi,

I am using the browser version of infopath. I have a drop down list box
whose look up values are obtained from a secondary data source. About 50
entries in the drop down. I have added a couple of rules to the drop down.

When I open the form in the browser and every time I select an entry from
the drop down it takes about 5 seconds until the entry is selected. This is
damn slow and the rules are nothing special.

As soon as I remove the rules the drop down becomes decent again.

Help.

Reply to this Message

Bryan Phillips - 07 Nov 2007 18:17 GMT

What rules are you using? Do they need to be run every time the
dropdown list is manipulated?

--
Bryan Phillips
MCT, MCSD, MCDBA, MCSE
Microsoft MVP - Client Application Development
Blog: http://bphillips76.spaces.live.com
Web Site: http://www.composablesystems.net

> Hi,
>
[quoted text clipped - 9 lines]
>
> Help.

Reply to this Message

zeon - 13 Nov 2007 20:59 GMT

I've had that same problem, but only when the list box contained thousands of
rows from a secondary data source. It is due to IP having to repaint the
screen, or possibly (re)build the HTML.

Get the SQL being generated by the data connection (tools, data connection,
choose the connection and click on the show sql button). Drop-down boxes also
take longer to populate if they are within a repeating section.

Then run just the SQL and see how long it takes. If it runs quickly, the
issue is in the form.

> Hi,
>
[quoted text clipped - 9 lines]
>
> Help.

Reply to this Message