You’re offline. This is a read only version of the page.
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
Anyone facing similar issues can try this batch SQL CRUD template
What was your formula in PowerApps for doing it? That is most likely where your slowdown was. It will be faster in PowerApps than in Flow.
Do you want me to share flow screen shot with you?
When I used patch function for insert and update , the performance was even worse . So I thought flow will drastically improve the performance but it did not
You will not get the same performance that you get in SQL server. That is a direct action on the datasource. PowerApps and PowerAutomate must perform through a different method that takes time to complete.
Is there any reason you chose to do these updates through a flow and not directly from your app?
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
