Question on Data loading

5 posts, 0 answers
  1. Ed Lance
    Ed Lance avatar
    61 posts
    Member since:
    Jun 2012

    Posted 12 Sep 2012 Link to this post

    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
  2. Ivana
    Admin
    Ivana avatar
    657 posts

    Posted 13 Sep 2012 Link to this post

    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
    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. UI for ASP.NET Ajax is Ready for VS 2017
  4. Ed Lance
    Ed Lance avatar
    61 posts
    Member since:
    Jun 2012

    Posted 13 Sep 2012 Link to this post

    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. 
  5. Mbott
    Mbott avatar
    24 posts
    Member since:
    Dec 2008

    Posted 14 Sep 2012 Link to this post

    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.
  6. Ivana
    Admin
    Ivana avatar
    657 posts

    Posted 17 Sep 2012 Link to this post

    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
    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.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017