I have an app connected to a PostgreSQL table where we update rows in bulk of 200. Currently, it takes about 8 minutes to update 150 rows. Is there any way to speed up the write-back process?
I would suggest using Power Automate instead. You can pass the IDs of all the items to update as a Variable in the flow upon a click of the Save button, use "Update Row (V2)" action within a For Each loop and update the rows one by one. You can use some ideas from this video but replace the SharePoint action with Update Row (V2) - https://www.youtube.com/watch?v=OnhljoOc2Hs
If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.