Is it correct that the AutoCompletebox loads the entire data, then filters it? I would have thought that it would use a parameterized query to limit the loading. The scenario I would use this for has several thousand rows ( and always increasing). Not sure which would be worse, making the page initially wait while everything loads, or repeated hits on the database as the user types.
Does the loaded data end up in Viewstate? The apps Viewstate is already getting really huge.
Thanks
Does the loaded data end up in Viewstate? The apps Viewstate is already getting really huge.
Thanks
4 Answers, 1 is accepted
0
Hi Ed,
RadAutoCompleteBox does the items' filtering on the server. This means that only the data matching the user input will be loaded on the client.
For example, if you have the Filter property set to "StartsWith" only the matches that start with the text typed in the input area will be loaded on the client.
The following help article explains more on the RadAutoCompleteBox's filtering: http://www.telerik.com/help/aspnet-ajax/autocompletebox-filtering.html.
I hope this will help!
Regards,
Ivana
the Telerik team
RadAutoCompleteBox does the items' filtering on the server. This means that only the data matching the user input will be loaded on the client.
For example, if you have the Filter property set to "StartsWith" only the matches that start with the text typed in the input area will be loaded on the client.
The following help article explains more on the RadAutoCompleteBox's filtering: http://www.telerik.com/help/aspnet-ajax/autocompletebox-filtering.html.
I hope this will help!
Regards,
Ivana
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
Ed Lance
Top achievements
Rank 1
Rank 1
answered on 13 Sep 2012, 04:12 PM
Thank you, but my question was not about what goes to the client, but what is pulled from the database on the server side.
Looks to me like you are not sending parameters to the database, but rather pulling an entire record set, and then filtering in the control.
Looks to me like you are not sending parameters to the database, but rather pulling an entire record set, and then filtering in the control.
0
Mbott
Top achievements
Rank 1
Rank 1
answered on 14 Sep 2012, 01:39 PM
Yeah, I have a similar concern about performance of this controrl with datasets that have thousands of rows. I tried caching the dataset and then have the control read from the cached ds, but I get a javascrip alert "object reference..." error.
0
Hi Ed,
Unfortunately, when a request to the server is initiated all the data from the database is retrieved. Then the data is filtered on the server, and the result is sent to the client. This, however, is different when the RadAutoCompleteBox is bound to a web service; here you are given the possibility to configure the query to the database in a way that it is a less time consuming.
We are already contemplating on changing the way the data is retrieved from the database. This will probably be a task scheduled with a high priority for the next major release.
I am very sorry for the inconvenience caused.
Regards,
Ivana
the Telerik team
Unfortunately, when a request to the server is initiated all the data from the database is retrieved. Then the data is filtered on the server, and the result is sent to the client. This, however, is different when the RadAutoCompleteBox is bound to a web service; here you are given the possibility to configure the query to the database in a way that it is a less time consuming.
We are already contemplating on changing the way the data is retrieved from the database. This will probably be a task scheduled with a high priority for the next major release.
I am very sorry for the inconvenience caused.
Regards,
Ivana
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.