Pauses in InfoPath at Drop-Downs

[Guest]

All,

I'm working with InfoPath SP1 and I'm getting some really bad lags when
selecting an item in a drop down. I've got a view that has three
dropdown boxes that have the same info in it (for separate categories).
There are approx. 4000 entries in it, and when I select one, it takes
more than 2 minutes before I get it back. These entries are Vendor
names and I need to have all of them. Why is it taking so long just to
click on an entry in a drop-down. That just doesn't make sense.

Thank you,

Michael Schnell

 

[Scott L. Heim [MSFT]]

Hi Michael,

You need to keep in mind that you are working with XML - as such, when you
load 4000 items into your drop-down list, under the covers we need to
create 4000 XML nodes as well. As such, a delay is to be expected.

Something you may want to look at is using another drop-down box first that
"filters" the vendor drop-down list so you are not pulling all 4000 entries
back. Each time a change is made to the "filter" drop-down list you
re-populate the vendor list appropriately. This may also have the added
user benefit of not having to search through so many entries.

I hope this helps!

Best Regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights.