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

TelerikGrid filtering problem

1 Answer 367 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Anna
Top achievements
Rank 1
Veteran
Anna asked on 04 Mar 2021, 10:36 AM
I use TelerikGrid with big data. Everything works fine except filtering.When I'm trying filter grid by name of customers, grid freezes. If I write text in filter slowly, grid filtering works fine, but when writing fast,filtering works after every change and that block my grid and it's broke. How can I prevent grid filtering after every change in string filter?

1 Answer, 1 is accepted

Sort by
0
Nadezhda Tacheva
Telerik team
answered on 05 Mar 2021, 03:15 PM

Hello Anna,

Indeed, when dealing with large portions of data filtering on every keystroke may result in slowing down the application performance.

Since the FilterRow mode uses filter-as you-type method as per design, there are a couple of approaches you may try:

  • You can use the FilterMenu mode as it fires filtering only when the user presses a button (the FilterMenu can be simplified to contain only one filter option)

  • Implement debouncing in the OnRead

  • Implement your own filtering

More details as well as examples for the above listed approaches you can find in this knowledge base article for Debouncing Grid data source operations.

In the meantime, we have an opened feature request for Adding Debounce property for grid filtering in our public feedback portal. I have added a vote on your behalf to increase its priority. You can also subscribe to receive email notifications on status change (this is the best way to know when a feature gets implemented as we announce such information in the feedback portal).

Another approach to consider might be using the Toolbar Searchbox to filter by strings. It currently has a DebounceDelay parameter which you can use to set the time with which the typing is debounced.

Regards,
Nadezhda Tacheva
Progress Telerik

Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.

Tags
Grid
Asked by
Anna
Top achievements
Rank 1
Veteran
Answers by
Nadezhda Tacheva
Telerik team
Share this question
or