telerik:RadSearchBox connected to large dataset

4 posts, 0 answers
  1. Kevin
    Kevin avatar
    6 posts
    Member since:
    Oct 2012

    Posted 10 Aug 2017 Link to this post

    I'm using the telerik:RadSearchBox and have it connected to a datasource/web service with autocomplete enabled.

    This datasource is connect to database table that has over 1 million records. On a page load or page preinit, the web page will timeout due to the large amount of data its trying to load.

    What is the best method for the telerik:RadSearchBox to connect to the datasource and populate the autocomplete feature with a large dataset?

    Thanks in advance.

    Kevin

  2. Carl
    Carl avatar
    4 posts
    Member since:
    Sep 2014

    Posted 12 Jan 2018 Link to this post

    We are facing exactly the same problem.  If I hobble my stored procedure the page loads extremely quickly.  What I find odd, why is the RadSearchBox firing the stored procedure before anyone begins searching for anything?  Is this an efficient approach?
  3. Carl
    Carl avatar
    4 posts
    Member since:
    Sep 2014

    Posted 12 Jan 2018 Link to this post

    Thinking about it might be useful if I give a scenario for the above.  I have a page with a number of control, one of them is a RadSearchBox which will search over 100,000 products.  When I load the page it's really slow, just loading, even leaving the page is slow.  Perhaps I won't use this search when I get to the page.  So in an ideal world, the control would do nothing unless I interact with it.  So in terms of data, size, it should have no bearing on page load times.
  4. Peter Milchev
    Admin
    Peter Milchev avatar
    859 posts

    Posted 16 Jan 2018 Link to this post

    Hello Carl,

    You are correct, the SearchBox indeed makes a request to the SQL server on initial page load and we have logged it as a bug in our Telerik Ajax Feedback and Ideas portal: Request to the SQL server is fired on PageLoad

    In order to avoid the initial request to the server you could use WebServices as demonstrated in the SearchBox - Various Data Sources online demo (Page Methods implementation for example). 

    I would like to focus your attention also on the RadComboBox with load-on-demand and virtual scrolling functionalities. Using them you would be able to load the items into portions. You can refer to the ComboBox - Load on Demand Modes demo and the ShowMoreResultsBox/Virtual Scrolling help article for live examples and additional information.

    Regards,
    Peter Milchev
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top