Combo Box Slow Load/Search

[jrtex]

I have a situation where we have a combo box that has over 19000 items to load. It is very slow to load. It is also very slow when searching for the correct item in the list when the main record changes. An example would be I have a list of accounts and each account could have a value(say City) that could be any one of large list in the combobox. It seems to search thru the whole list, even scrolling each value in the box until it finds the right one.

Is there any way to speed up the process in finding the correct item in the combo? Also, is there any way to speed up the process of loading the combo when you have so many items. If not, any thoughts on a better way to do it would be appreciated.

Thanks

JR

 

[zemp]

What exactly are you doing? Are you pulling large amounts of data into your app so that you can search through them to find a record? Or are you using a combo box to store a list of possible values when entering a new record?

In case one you should do your search through SQL. Use the SQL statement to search for specific records in your databse. This will greatly reduce the number of records that you are trying to pull over and increase your speed.

In the second case, you should use a combo box for selection of a finite list of posibilities that is not too large. The possible number of cities is huge making the seletion of cities via a combo unpractical. It would work well for the selection of states. Just use a text box for entering the cities.

If I am not even close in my guesses then please clarify your situation and post more details. Thanks and Good Luck!

zemp

 

[jrtex]

Zemp,

I am trying to pull in a large amount of data into a combo box that a user then could select from. The users were looking for a combo box of codes that total over 19000 but as you noted this is the wrong way to go about it and I'm just trying to come up with a better way. Users sometimes don't take into consideration performance issues when defining what they want.

Thanks for the feedback

JR