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

AutocompleteBox with large source (~12k)

1 Answer 100 Views
AutocompleteBox
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Charles
Top achievements
Rank 1
Charles asked on 03 May 2012, 11:28 PM
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.

1 Answer, 1 is accepted

Sort by
0
Deyan
Telerik team
answered on 04 May 2012, 03:28 PM
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 >>

Tags
AutocompleteBox
Asked by
Charles
Top achievements
Rank 1
Answers by
Deyan
Telerik team
Share this question
or