Autocomplete with many items

[Slavcho]

Hi,
I’m  just evaluating your great gridview control and plan to use it in my future project as grid with a list of products. It must have a insert product functionality, so I need to replace the editor of standard text column with dropdown or another editor with autocomplete functionality.
The problem is that the products in selection are more than 30000 and there is some problems with performance when a text is typed in the editor and the control do the autocomplete operation. Another problem is that I must reload the editor datasorce every time on EditorRequired/EditorInitialized event although actually there is no changes in the datasource.
So my two questions are:
Is there a better approach to achieve autocomplete with lot of (30-50k) items without so many lag when typing?
And
Is there a way to use a editor without loading the datasource every time when the editor is required?

Thanks in Advance!
Slavcho

[Tom]

In my opinion, autocomplete is only good when return less than 20 items, you have to limit the number of return records and let user keep typing to filter down the list.
And I think autocomplete is for web version, you are in winform forum.

Regards.

[Tom]

sorry, I found the autocomplete in Editor section of Winform.

[Dimitar]

Hello Slavcho,

Thank you for writing.

In this case there is no need to bind the column in the EditorInitialized event. In the following article you can find out how you can bind the GridViewComboBoxColumn: GridViewComboBoxColumn. 

Currently, there is no way to limit the number of items in the drop down and speed up the filtering. However you can check the solution for such cases provided in the following article and see how it fits in your case: Performance Boots with Virtual RadMultiColumnComboBox - Quick Loading and Fast Filtering using Trie

I hope this information helps. Should you have any other questions, I will be glad to assist you.

 

Regards,
Dimitar
Telerik