Grid filter big data

[n/a]

Dear support we have a data grid with 30 columns and 5000 rows, when we try to filter by `process` function the system responds quite slow (it freezes the ui). 

Overview - Data Query - Kendo UI for Angular (telerik.com)

Do you have any suggestion?

[Srinivas]

Implement server side filtering with https://www.telerik.com/kendo-angular-ui/components/grid/filtering/built-in-template/

[Svet]

Hi Ioannis,

Indeed the reported behavior is expected. In general performing any heavy operations on the client might lead to a browser freeze. That is due to each browser and machine having a limited amount of resources. What should be done in such cases is to perform the data operations on the server and return the processed data to the client. To be more specific on (dataStateChange) event of the Grid a remote request containing the current Grid state (which includes the currently applied filters) should be sent to the server. Then apply the filtering on the server and return the data to the client and Grid respectively. You can also apply paging to the Grid. That will further speed up the rendering of the Grid as the browser will have to render just the data for the current Grid page.

Regards,
Svet
Progress Telerik