Combo Box very slow

[berto]

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? 

[Nencho]

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

[berto]

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.

[Nencho]

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

[berto]

OK I will open service request....