For example if have 50+ columns, 5000+ rows with hyper formulas. And we save these data in PostgreSQL db with row number. So after if we add a row in top or center the formulas will be change right. So when saving to the db it will affect lot of changes right.. So what we can do for it.. What is the best and optimized solution to save these changes. If have multiple solutions please give. Need an answer quickly.
Thank You.
Hi @dilshanrangaka ,
In many cases, only the input data is stored, to avoid the sync issues you mentioned. If you need the calculated values stored, then you have to write your own update logic based on the affected rows. It will help to use a unique ID instead of the row number.
The batch() method can be used to perform multiple calculations before saving the rows. But this is more about the batch calculation, not the batch updating of database rows.
Hope this helps!
___
If you have an active support plan, please open a ticket by emailing support@handsontable.com.