DataTable component - pagination with filters performance

[pegeraw]

Hello,
I have DataTable component with 12 columns and 4000 rows.
Everything works perfect like page changing etc until any filter applied. When global search and sorting on particular column are used changing pages is really slow.
Its required to have all this data on frontend side besides it's not that much.
What can be reason for this slowing down? One solution is to implement lazy loading fully on frontend i guess.
Edit:
I found that DataTable doesn't store filtered array of records, but calculates it on every event, probably because of possible data changes.
I know exactly when data will be refreshed. Can I update directly somehow filter function to use my own where I can use cached filtered array and provide it or the only solution is by lazy loading feature fully on frontend?

Best regards!

[tugce.kucukoglu]

Hello,

You can try to using lazy loading and 'rows' prop for saying how many row should be loaded at one time. In frontend it is the best way. Because while data is growing in 'backend', the datatable is slowing in 'frontend'.

Best,