Large amount of data, inserting multiple rows

Hello, when using the table, my data source is an array of objects. Regarding the custom insertion of contextMenu when dealing with large data volumes, I need to insert multiple rows and also need to fill in the data. The data for filling in comes from right-clicking to insert rows. I know that using insert_row_above and setDataAtCell can accomplish this. The data source of the table is an array of objects, and the data volume is quite large. If using the above method, the table will become sluggish. Are there any better ways to handle this?

Hi @en_kang

The methods you mentioned are the recommended way to do this. If the performance isn’t optimal enough you can try to batch some of the operations Batch operations - JavaScript Data Grid | Handsontable

Additionally, we are working on the implementation of pagination for Handsontable, that would allow to split the large data sets. It’s still work in progress but I will let you know once it’s ready if that solution would meet your requirements.

Thank you. Could you please provide an example? The data source is an array of objects. Multiple pieces of data are inserted at once, and the data comes from the current inserted row.

I’d like to follow your writing style, as it is more effective. Thank you ever so much

@en_kang

The examples are in the guide I linked in my previous message. The implementation of this method depends on the logic of your application.