CODEWITHSUNDEEP
asp.netdata-bindingdrop-down-menu
Prabhavith
Prabhavith

Reputation: 486

ASP.Net page loading

I have a asp.net page in which i have 3 dropdown's each dropdown takes 30k rows from a storedprocedure. The storedprocedure takes 8 seconds to execute and populate the rows which is the datasource for those dropdowns. Now seeing this my page should take at max 15 seconds to render and load but it is taking 25 seconds can any one help on this.

Upvotes: 0

Views: 249

Answers (2)

skub
skub

Reputation: 2306

Having a dropdown list of that size is quite concerning in regards to usability and performance as you have noticed. I think your best option is to have a look at alternatives such as telerik's combo box (pricey) or ASP.NET Ajax's autocompete:

Hope that helps.

Upvotes: 0

Aristos
Aristos

Reputation: 66641

To load this amount of data on drop down list, is first of all bad user internface because no one can search on drop down list to find this among 30k of lines, and also the browser suffer try to handle this data.

The most easy way that I suggest is to change the drop down list to auto complete control.

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

Upvotes: 2

Related Questions