| Issue 419: | How to improve the performance of dropdown list loading in asp.net 1.1 09-09-2009, 1:10 AM | |
| 2 people starred this issue and may be notified of changes. | Back to list |
|
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
Apr 17, 2010
(No comment was entered for this change.)
Status:
WontFix
|
||||||||