Infopath 2007 / Forms server // MOSS // performance of drop-down list

[galvin.paul]

Greetings,

We have a browser based form with a drop-down list that is populated
from a Sharepoint 2007 (MOSS) list. That list contains vendors (name,
address and other mundane info).

We want to do the classic thing of picking a vendor form the drop-down
list and populate name/address/city/state/zip, etc based on the
selected vendor.

There are just 350 or so vendors in the list and it's taking 17
seconds and killing the server's CPU when we do this.

If run from within the infopath client itself (not the browser), it's
basically instant.

Is there anything I can do to solve this?

Regards,

--Paul Galvin
Conchango

 

[Kalyan G Reddy MVP (GGK Tech)]

Hello

Are you Populating the data onload?
You can use a search box and get the data instead