hyperformula icon indicating copy to clipboard operation
hyperformula copied to clipboard

Published 20 hours ago • verified publisher icon handsontable

Slow graph building with 500k of rows without formulas

Open crystalstone opened this issue 3 years ago • 3 comments

hi， we use handsonetable + hyperformula to develop sheet like excel. But we find when setSheetContent or buildfromsheets with huge datas may has bad performance.

demo: setSheetContent 50w rows data (do not has any formula) will cost 50s https://jsfiddle.net/rdfa45vp/21/

but spreadjs just cost 2~3s

crystalstone avatar Dec 15 '21 09:12 crystalstone

Hi @crystalstone

Could you please check the tips on the performance that I've just posted at https://github.com/handsontable/hyperformula/discussions/871 I hope they will help.

AMBudnik avatar Dec 20 '21 11:12 AMBudnik

Maybe related: #872

warpech avatar Feb 09 '22 17:02 warpech

When completed, please re-verify https://github.com/handsontable/handsontable/issues/8118.

sequba avatar Jun 28 '22 09:06 sequba

Related: https://github.com/handsontable/hyperformula/issues/1272

sequba avatar Jun 27 '23 12:06 sequba

Test based on the initial demo shows significant improvement in the described scenario.

2.5.0

Loading time ~ 55s

2.6.0

Loading time ~ 11.5s

adrianszymanski89 avatar Sep 15 '23 11:09 adrianszymanski89

Hi @crystalstone

I'm more than happy to announce that HyperFormula v2.6.0 is here, and it significantly improves the loading time of the example.

ps. Here https://hyperformula.handsontable.com/guide/release-notes.html#_2-6-0 you can read more about the changes within this version.

AMBudnik avatar Sep 19 '23 08:09 AMBudnik