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.