Improve Logic App Execution time

Chandan B 1 Reputation point
2020-12-12T09:18:53.613+00:00

We have created a logic app which would read the data from a Staging table from Azure Data Explorer and would expand the data using the Azure Data Explorer. Once expanded it would then push the data back to Azure Data Explorer to another table. This entire process takes around 1.5 hrs since we are fetching around 6k records from Staging table and we are writing around 9k records into the Azure Data Explorer table.

Below are the detailed steps:
1. Extract Data from Staging Table

47539-image.png

  1. Iterate through the records obtained from step 1(Here we are iterating over 6.2k records)

47563-image.png

  1. Once done we would expand the data which generate records and added into the table in Azure Data Explorer:
    47439-image.png

Since the entire process is taking around 1.5 hs we would like to optimize this execution. How do we increase the compute capacity of logic apps so to speed up the execution and to perform the operations quickly.

Is there a way to increase the memory or the compute instance for logic apps. Kindly provide with the optimized approach for this.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,965 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
502 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JayaC-MSFT 5,526 Reputation points
    2020-12-15T13:43:11.997+00:00

    @Chandan B Have you enabled the concurrency control and set any degree of parallelism?
    https://www.serverlessnotes.com/docs/logic-apps-improve-performance-using-parallelism

    0 comments No comments