Slow performance when over 1k nested header columns

Questions
,
1

Grid takes a very long time to load, at times can even time out cause of memory usage, after loading the navigation seems slow and laggy.

Added an example demo.
You can add more columns at line 105 or rows at line 107, also if you remove nested headers at line 204 then the grid loads fine and there is no scrolling or navigaition issue.

https://codesandbox.io/p/sandbox/fdxrvm

Hope this is helpful,
Thanks in advance.

2

Hi @vmendez

Thank you for contacting us. Such amount of data might have the impact on the performance, especially with more complex structure, like nested headers. In such cases we recommend to minimize the calculations needed to be performed by the table’s engine by setting dimensions such as height of the table. I added the height value to your example and that fixed the issue with the scroll performance: https://codesandbox.io/p/sandbox/handsontable-nested-header-forked-gmjcnz

3

Thanks for the tip, however in our project we are having issues with initial load on tables with nested headers, depending on the amout of data loaded it can take up to 30 seconds, do you have any recomendations on initial load, to make it faster?

4

@vmendez

That will always depend on the amount of data being loaded. Recently we introduced the loading screen that can be shown during the table initialization: Loading - JavaScript Data Grid | Handsontable