Hi,
I want to bulk to bulk insert and update to sql server using flow.
As of now 30 records, insert and update is taking around 19 second time when the table is empty.
If I run insert and update statement from sql server it takes around 2 second to perform the operation for 30 records.
As of now I am passing collection which needs to be inserted or updated as parameter to flow and then running for each statement in flow to insert and update records in sql.
Is there any better way to improve the performance?
Thanks in advance