Loading

Dropdownlist Performance issue while binding more than 15000

Dropdownlist Performance issue while binding more than 15000

chetan tembhre

13y5.4k.NET

Hello,

While binding more than 15000 rows into dropdownlist then page is hanged up. I am using the mentioned below code for this.

ddlList1.DataSource = ds.Tables[0];

ddlList1.DataTextField = "EmpID";

ddlList1.DataValueField = "EmpName";

ddlList1.DataBind();

Can anyone please help me for trouble out this problem.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Riyaz Akhtar13y ago
I am agree with Mr. Raj. Loading 1500 record in dropdownlist will cause performance issue.
No user wants to select from such huge record.s
According to me, you can use autocomplete, see some example in below link
http://www.aspdotnet-suresh.com/2012/09/9-top-ajax-jquery-autocomplete.html

OR

Dont use dropdownlist, use readonly textbox for employe and give a option(button/iamge) to select the employee .
Open a popup page and use grid with search emplyee functionality.
give option here to select the employee.
Iftikar Hussain13y ago
Hi,
It is not a good idea to load so many records into dropdown. Even though it loads, it will be difficult to user to select particular value from the dropdown. I suggest you can use autocomplete ajax textbox. Please refer the below link

http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx

http://www.asp.net/ajaxlibrary/act_autocomplete.ashx

Regards,
Iftikar
Raj Bandi13y ago
Hi Chetan,

15000 items in a dropdown?. My advice is not to load so many items in it at a time. It degrades browser performance.

Try to use

load on demand technique like an auto complete textbox from AjaxControlToolKit.
or
Build your own control that loads subset of items from server on some scroll change event (ajax )

Cheers,
Raj