TelerikGrid filtering problem

[Anna]

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?

[Nadezhda Tacheva]

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