HandsonTable editing is slow for more records like 500 and more in IE 11 if providing RenderAllRows:true

Tags: #<Tag:0x00007efc6a336c70>
#1

In my Handsontable i’m having records more than 800 to 1000
If using RenderAllRows then scrolling is working fine but then editing on each cell becoming slow.
Its hanging and sometime crashing with huge records .For small records its working fine.
Please provide some solution.
This is big issue facing.
please reffer this link https://jsfiddle.net/13Poonam/09jfdd9e/1/

#2

Hi @13poonam90

renderAllRows is not made to be used in large data sets. Is there any particular reason why you use it there? IE is much slower than other browsers so there’s not much we can do.

#3

My Handsontable have nearly 1000 records… We are using IE 11…because our project will support only in IE.
In handson table we are doing Group of records and some formauls for calculation and some auto complete also…
Once data loaded in table… user will edit the details and update…
I m facing issue in Scrolling & Editing record
But If i have less data i.e less that 50 than Scrolling & Editing of row working fine.
But more than that it make my handsontable slower …
Kindly sugest me some solution… other give some alternate

#4

@13poonam90
formulas has always been an alpha version of the plugin and currently it may have a big influence on the performance. Can you reload the example again? The table doesn’t load at all.

#5

http://jsfiddle.net/13Poonam/urq6ernd/3/
Please go through above link and check this link in IE.
Scrolling is not working in IE, its lagging completely. And editing too slow.
But this Handsontable is Much useful to Us if its works fast and user friendly.
Only issue we are facing is Slow in scrolling & Editing.

Waiting for your positive response

#6

Hi @13poonam90

I can see that turning off formulas won’t help us much. I guess that it’s just the IR performance bug, just the one that we’ve been reported a long time ago: https://github.com/handsontable/handsontable/issues/2350

We did some changes to make it work better but still IE is way behind other browsers.

#7