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

GridView performance of filtering

2 Answers 118 Views

GridView

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

Daniel asked on 31 May 2012, 09:21 AM

1.JPG

2.JPG

Hallo,

Version: 2012.1.301

I use the custom filtering functionality like in Telerik demo "Custom Filter Row" (see attachment 1.jpg)
For the custom filtering I used the source code from this demo: (see attachment 2.jpg)

In my GridView are 16 columns and 300 rows. The performance of filtering is very bad.

In our scenario it is possible, that the count of rows is greater than 50.000 - 60.000.

Telerik's answer:
"The Demo application uses string based comparison of data for the search functionality, and string based comparison is an expensive operation. This example just aims to demonstrate a possible solution regarding the custom filtering operation, and it does not intent to achieve the best possible performance. The solution there is up to the developer that is going to make the comparison. For example, in order to have good performance in this scenario, you may need to implement some kind of indexing functionality and cache the result in a memory data structure based on row and column indices. RadGridView in the case of custom filtering only gets the result and sets Visible property for every row.

Speaking in the context of the built-in supported filtering features, the current version of RadGridView control does not implement built-in indexing algorithm for full text search. More information about text search you can find in this stackoverflow discussion.

I hope this information is useful."

This answer is not sufficient.

Please help me, I need a high-performance solution!

best regards,

Daniel

GridView performance of filtering

2 Answers, 1 is accepted