Searching DevExpress TreeListView with more than a million items

Question

I am building a TreeListView (DevExpress) with more than 5 million rows. (Around 15 million rows)

I wonder how should the searching work in that case as the user won't be expanding all the branches for searching. And the existing search in TreeListView allows the search only if the nodes have been expanded.

Also, Should I search it on my datasource or should I search it in the TreeListView control?

Also, if we we use paging and dynamic loading for loading the items, it's possible to search through the data source but how can I show the results in the TreeListView?

Answer 1

the existing search in TreeListView allows the search only if the nodes have been expanded

This is not correct. Set the TreeListView.ExpandNodesOnFiltering-property to true and set the TreeListView.FilterMode to either Smart or Extended.

I never had problems with searching in the GridControl and I doubt that you'll be able to create a faster search-mechanism yourself ;)