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.
This answer is not sufficient.
Please help me, I need a high-performance solution!
best regards,
Daniel
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
2 Answers, 1 is accepted
0
Daniel
Top achievements
Rank 1
Rank 1
answered on 01 Jun 2012, 11:39 AM
RadGridView control does not support full text search functionality built-in.
Has anybody a suitable workaround with acceptable performance for this problem?
Please help me! I can't use the GridView with this bad performance.
Daniel
Has anybody a suitable workaround with acceptable performance for this problem?
Please help me! I can't use the GridView with this bad performance.
Daniel
0
Daniel
Top achievements
Rank 1
Rank 1
answered on 01 Jun 2012, 11:41 AM
There are a Issue for a full-text search functionality built-in
http://www.telerik.com/support/pits.aspx#/details/Issue=11300
Please vote!
Daniel
http://www.telerik.com/support/pits.aspx#/details/Issue=11300
Please vote!
Daniel