Issue 419: How to improve the performance of dropdown list loading in asp.net 1.1 09-09-2009, 1:10 AM
Status:  WontFix
Owner: ----
Closed:  Apr 2010
Reported by gitachel...@gmail.com, Jan 25, 2010
My current project is done using asp.net 1.1 version. Anthem panel
(Anthem.net) is used in the pages. Some of pages has many dropdown lists
which has dependent values in it.

On changing of value in one dropdown, other dropdown values to be filled
up. In local environment it is loading reasonable time. But in the
production server, it takes more time to load the values in the dependent
dropdown lists. The values loaded in the dropdown lists are master values,
so hopefully it wont have large no. of values.

I am unable to find out the reason for the poor performance of dropdown
list loading.

The items are added to the dropdown lists, by looping through the result
set (dataset) and added one by one. They are not binded with direct way
(ie. Dropdownlist1.Datasource = dataset). Will it be reason for poor
performance? My code for binding the dropdown list is written as:    

 Dim dsProbSubToProbCMap As New Data.DataSet
            Dim strvalue As String
            strvalue = Problem_Category.SelectedValue()
            If (strvalue = "") Then
                Return
            End If
            dsProbSubToProbCMap = CType(Cache.Get("dsProbSubToProbCMap"),
DataSet)
            dsProbSubToProbCMap.Tables(0).DefaultView.RowFilter =
"Category_ProblemCategory='" & strvalue & "' "
            Problem_SubCategory.DataSource =
dsProbSubToProbCMap.Tables(0).DefaultView
            Problem_SubCategory.DataTextField =
"Problem_SubCategory_ProblemSubCategory"
            Problem_SubCategory.DataValueField = "Problem_SubCategory_Code"
            Problem_SubCategory.DataBind()
            Problem_SubCategory.Items.Insert(0, New ListItem("[Select ]", ""))

What might be reason for slowness of dropdown list binding - can anybody
give me suggestions on this?

Expecting your reply on this regard. Thanks in advance.

If you need any other details please revert me.

Regards,

SHAN       


        
Feb 1, 2010
Project Member #1 nyro...@gmail.com
I don't see any links with nyroModal. Did I miss something ?

Moreover, I'm not a .Net dev, so I can't help you.
Apr 17, 2010
Project Member #2 nyro...@gmail.com
(No comment was entered for this change.)
Status: WontFix