Unanswered

SQL stored procedure takes time to run in Flow

(0) Share

Report

Posted on by Mayank Microsoft Employee

I am running a MS Flow which runs a Kusto control command followed by a SQL execute procedure. The Kusto command pushes the data into a sql table(around 1500 records). The procedure then runs on top of this table. The problem I am facing is, Kusto command gets executed within seconds whereas procedure takes several minutes to execute. When I run the procedure from SSMS, it hardly takes seconds to run.

Any help ??

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

v-xida-msft on at

Like (0)

Report

Hi @Mayank,

Could you please share a screenshot of your flow’s configuration?
The execution time of “Execute stored procedure” action would be affected by the amount of data in SQL table.
You could take a try to create an index in the SQL table and check if the issue is improved.

Best regards,
Kris

Was this reply helpful? Yes No
Foxxx 17 on at

Like (0)

Report

Hey @Mayank,

Did you ever found a sollution for this issue?

Thanks in advance,

Was this reply helpful? Yes No
takolota1 4,974 Moderator on at

Like (0)

Report

If you just need to do something like create or update a lot of SQL rows, you could try a part of this template & see if the batch create or batch update runs faster than the stored procedure.

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/SQL-Batch-Create-Read-Update-and-Delete/td-p/1715338

Was this reply helpful? Yes No