Performance warning for column filters data in v15.2

Getting help Issues
,
1

This issue is not yet resolved, Please check this again in repro-> handsontable (forked) - StackBlitz
When I try to open filter dialog, its super slow for large list.
My previous issue was Performance warning for column filters data in v15.0

2

Hi @inder.singh

Within 50k rows I would already recommend adding pagination to the project. At the moment we do not have this functionality (yet). However, that might help to improve not only performance but also UX.

Alternatively you can also use pagination on the frontend like so Handsontable example - JSFiddle - Code Playground and add an input outside Handsontable to filter our the data. That should work faster as then Handsontable does not need to render the list of values within the menu.

3

Hi @aleksandra_budnik I agree with your suggestions, but check out same example in version 14.6 Handsontable example - JSFiddle - Code Playground and then please compare the performance of filter dialog with version 15. You will find out v14.6 was very efficient.

4

Could you please try the Handsontable v15.3.0 as well? It performs much better than 15.2.0. You cab read more about it here Handsontable 15.3.0: CSV Sanitization, Accessibility Updates, and 30+ Fixes

5

No, page is crashing in v15.3.0 while opening, at least filter was opening in v15.2.

  1. v15.3.0 (50000 rows)-> handsontable (forked) - StackBlitz
  2. v15.2.0 (50000 rows)-> handsontable (forked) - StackBlitz
  3. v14.6 (100000 rows)-> Handsontable example - JSFiddle - Code Playground

image
image1569×931 49.4 KB

6

Thank you.

We will review that and be back with new after the weekend.

7

Hi @inder.singh

Thank you again for sharing resources. I tested the demos with our QA and they confirm that there are some performance issues.

I will pass the issue for further review and update you as soon as I get any news.

1 Like