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

telerik:RadSearchBox connected to large dataset

3 Answers 230 Views
SearchBox
This is a migrated thread and some comments may be shown as answers.
Kevin
Top achievements
Rank 1
Kevin asked on 10 Aug 2017, 03:58 PM

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

3 Answers, 1 is accepted

Sort by
0
Carl
Top achievements
Rank 1
answered on 12 Jan 2018, 09:58 AM
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?
0
Carl
Top achievements
Rank 1
answered on 12 Jan 2018, 10:20 AM
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.
0
Peter Milchev
Telerik team
answered on 16 Jan 2018, 07:58 PM
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.
Tags
SearchBox
Asked by
Kevin
Top achievements
Rank 1
Answers by
Carl
Top achievements
Rank 1
Peter Milchev
Telerik team
Share this question
or