AutocompleteBox with large source (~12k)

2 posts, 0 answers
  1. Charles
    Charles avatar
    1 posts
    Member since:
    Aug 2012

    Posted 03 May 2012 Link to this post

    Hi, I am currently using the silverlight toolkit AutoCompleteBox and was hoping to get some performance gains by switching to the Rad AutocompleteBox.  I made some adjustments to how I use the silverlight toolkit version to try to improve load performance and responsiveness, but they seem to fluster the Rad control.  That said, do you have any guidance on using a set this large?

    Currently, I wait until the user types 3 characters into the box before fetching the possible completions from a local SQLCE DB on the phone and then set the source to the resulting collection.  Whenever those initial three character change, I hit the DB and swap the source.  This means instead of loading up 12k entries, I have ~5-100 entries with the average being closer to 20 or so.  I am doing a contains comparison, not startswith.  With the silverlight toolkit version, loading up the entire data set resulted in poor responsiveness whenever the user added characters or backspaced (understandable) + a terrible initial load time.  The current solution works, but is still less than ideal.

    Any suggestions appreciated and let me know if I can provide more info.

    Charles.
  2. Deyan
    Admin
    Deyan avatar
    2038 posts

    Posted 04 May 2012 Link to this post

    Hi Charles,

    Thanks for contacting us.

    Before getting to your question I'd like to clarify a bit how RadAutoCompleteBox works. When you provide an items source it gets initially sorted. This is needed since when the filtering starts, it is performed incrementally (each filtering step is performed on the result set from the previous) - which acts as a performance improvement. So, when you provide an items source containing more items, it may pose a performance hit when the control initializes.

    I believe in your scenario the best approach would be to use a new feature that will be soon released which gives the possibility to use a third-party data source to provide filtered suggestions (like a webservice or database).

    However, it will be great if you can send me a demo project that sheds some more light on your scenario so that I can directly take a look and see how I can help.

    Please note that you will have to open a new support ticket in order to be able to attach your files.

    Thanks for your time.

    All the best,
    Deyan
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. DevCraft banner
Back to Top