RadGridView filter row takes a long time to filter when the grid has many rows.

[F3M]

I have a grid with 60,000 records and I have the filter line at the top of the grid. When a user writes to the filter line, it takes a few minutes for the grid to be filtered.

Telerik version is 2021.2.511.40.

Are there any performance improvements in newer versions? Is there a guarantee that if we update the Telerik version this problem will be resolved?

[Dinko | Tech Support Engineer]

Hi,

I appreciate your continuous interest in our Telerik UI components for WinForms.

We haven't made any significant improvements to the filtering mechanism of the RadGridView control. In general, populating the control with 60 000 rows should not take several seconds to filter. In my opinion, something else requires more time and slowing down the filtering process. 

I will be happy to further investigate why the filtering is taking more time than expected in your scenario. Now to start from somewhere I have created a sample test project and populated the RadGridView with 60 000 rows. If I type in the filter test box for the second column, the rows are filtered correctly and do not take more time. Here is a GIF file that demonstrates the steps: 

You can check my test project attached here as the GIF file could have some lag during display.

Regards,
Dinko | Tech Support Engineer
Progress Telerik

[F3M]

Hello.

 

I downloaded your project and made some changes to replicate my scenario.
In this case, I simply added more columns.

When filtering on any column the process is very slow, The more columns I add, the slower it gets.
The problem becomes even worse if I group the grid by one column for example.

The filtering process seems slow if I type faster or when I delete faster with backspace.

To help you diagnose the problem, I attached your project with the changes to add more columns.

I also attached a zipped video of the typing experience. At the start of the video, I was typing fast. At the end, I was typing a number 1 by 1.

 

I will wait for an answer.
Thank you.

[Dinko | Tech Support Engineer]

Thank you for the updated project. Indeed, I have observed some lagging while filtering different columns. The filtering functionality is triggered on each key stroke. Also, typing in the filter text box in different columns will re-evaluate the filter descriptors in other columns. This could lead to some lagging when having a large number of data cells. What I can suggest to improve the filtering behavior is to perform the filtering not with each key stroke but when the Enter key is pressed. A sample approach is demonstrated in the following KB article: https://docs.telerik.com/devtools/winforms/controls/gridview/filtering/how-to/filter-on-enter. Can you give this a try and let me know if this approach will work for you.