This is a migrated thread and some comments may be shown as answers.

Combo Box very slow

4 Answers 57 Views
ComboBox
This is a migrated thread and some comments may be shown as answers.
berto
Top achievements
Rank 1
berto asked on 14 Aug 2012, 10:55 PM
I replaced native DDL with Combobox:

<telerik:RadComboBox ID="ddlPatientSuchwort2" Runat="server" Culture="de-DE"
             DataSourceID="sqlWinacsPatientSuchwort" DataTextField="Suchwort"
             DataValueField="PublicNummer" AutoPostBack="True"
             EnableAutomaticLoadOnDemand="True"
             onselectedindexchanged="ddlPatientSuchwort2_SelectedIndexChanged"
             filter="StartsWith" EmptyMessage="W√§hle Patient Name" Skin="WebBlue" >
           </telerik:RadComboBox>

Data source is stored procedure which returns about 8000 rows in format ID, Name

Now performance is terrible, before result was displayed immediately, now even on DEV machine I need to wait few seconds, but in prod environment event more than 5 secs. At the current stage system is almost not usable. Any ideas how Ican improve performance? 

4 Answers, 1 is accepted

Sort by
0
Nencho
Telerik team
answered on 15 Aug 2012, 10:39 AM
Hello Andrzej,

To improve the performance of the control you could use the ItemsPerRequest property and set the desired value instead of loading all of the data to the RadComboBox. Thus, you could significantly decrease the time needed to show the items in the RadComboBox. Also, I would like to ask you why you use the AutoPostBack property and set it to true? Is this required by your scenario? If so, keep in mind that setting the AutoPostBack property to true and using the LoadOnDemand mechanism, a new data bind is performed after each selection in the RadComboBox, thus deteriorating the performance.

Greetings,
Nencho
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
berto
Top achievements
Rank 1
answered on 15 Aug 2012, 11:11 AM
I can't use Items per request because sometimes whole list should be returned. Post back i use to get data based on clicked Person ID from database and dispay them in separate Grid. I understand small performance decrease but at the current stage it is almost not usable as this system works in small clinique and we have very often new people.
0
Nencho
Telerik team
answered on 16 Aug 2012, 08:05 AM
Hi Andrzej,

Could you elaborate a bit more on the scenario you are trying to implement. I have noticed that  you perform the DataBinding with a SQL data source. If so, could you explain what is your purpose in using the property EnableAutomaticLoadOnDemand?

In addition, there are several ways to improve the performance of the RadComboBox, but we need to be aware of the specific scenario that you use. For that matter, could you please provide us the implementation of the databinding, along with the stored procedure, so we could observe the issues locally and offer you a suitable solution for your particular case?

All the best,
Nencho
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
berto
Top achievements
Rank 1
answered on 16 Aug 2012, 06:10 PM
OK I will open service request....
Tags
ComboBox
Asked by
berto
Top achievements
Rank 1
Answers by
Nencho
Telerik team
berto
Top achievements
Rank 1
Share this question
or