Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

asp.net dropdownlist caching for Huge data

I have to bind nearly 50k records to my asp.net dropdownlist and it has to be searchable. What is the best way to do implement it . Are there any caching techniques so that the list loads as we scroll?Appreciate the suggestions.

Please advise.

like image 725
user1046415 Avatar asked Jan 28 '23 19:01

user1046415


1 Answers

I'd recommend taking advantage of jQuery's autocomplete plugin:

https://jqueryui.com/autocomplete/

It's configurable and has autocomplete search out of the box. It can also consume your remote data source (though you might consider a paginated API response):

http://api.jqueryui.com/autocomplete/#option-source

like image 88
Adam Avatar answered Jan 31 '23 07:01

Adam