Combo Box very slow

5 posts, 0 answers
  1. berto
    berto avatar
    40 posts
    Member since:
    Jul 2012

    Posted 14 Aug 2012 Link to this post

    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? 
  2. Nencho
    Admin
    Nencho avatar
    1796 posts

    Posted 15 Aug 2012 Link to this post

    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.
  3. berto
    berto avatar
    40 posts
    Member since:
    Jul 2012

    Posted 15 Aug 2012 Link to this post

    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.
  4. Nencho
    Admin
    Nencho avatar
    1796 posts

    Posted 16 Aug 2012 Link to this post

    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.
  5. berto
    berto avatar
    40 posts
    Member since:
    Jul 2012

    Posted 16 Aug 2012 Link to this post

    OK I will open service request....
Back to Top