Dropdown Datawindow Search Performance Issue

[Encapsulator]

Hi,

I have a dddw that can have 30,000+ records loaded into it at runtime. It is already sharing data with a global datastore object as an effort to increase preformance. The project spec requires that I load all the data into this dropdown so I can't apply a filter. This dddw consists of one compute field which concatenates several fields together.

The default incremental search is painfully slow when this object is connected to one of our larger databases. I commented out all code in the itemchanged() event to be sure nothing is executing when the user is entering data in the control..but to no avail. Any suggestions?

 

[mbalent]

So you have your dddw with its 30000 records in it. The user types in a value and then you do some sort of search based on their input? or are the records retrieved as a result of the input? Please elaborate.

 

[Encapsulator]

No, I just load the list...no special code for conducting a search.

I found out the problem has to do with the display column property of the dddw. When I set it to the same field as the data column property it would incrementally search the list very quickly. So...I changed the datawindow containing my dddw to also include a duplicate column referencing the same dddw, but I use the concatenated string field as the display column (for display purposes only) there. This is a bit of a workaround but I can live with it.