Load a combobox with 90,000 values

I am trying to load a combobox with 90,000 records from database. But the combobox is taking a lot of time to load …nearly 40 seconds and it crashes.
I am loading it from database using .net dataconnector. It uses ashx file and returns the data. The data has to be autocompleted or filtered when user inputs in the combobox. I tried it with dynamic loading also but still its taking a lot of time to load and the page crashes .

How to get auto suggestion while loading such a large amount of data. I am getting autosuggestion correctly when loading a small database.


  1. You can try any filtering/grouping mode from samples (including onDynXLS usage):
    dhtmlx.com/docs/products/dht … g_sorting/
  2. And set autocomplit:
    dhtmlx.com/docs/products/dht … plete.html