API in Logic Apps is slower compared to .NET Rest API

Question

Hi, I have created a API using Logic Apps but it apparently slower than a Web API which i built from Visual Studio. The execution time of the Web API which I built using .NET is within milisecond but the API which built from Logic Apps took 5 seconds to 20 seconds. What can we do to improve the execution time? As this will be a API which will be executed by our partners.

Answer 1

Hi,

You can expect Logic Apps to be slower than a Web API. It's by design, and Logic Apps are not recommended for really time critical or real time API response times.

That said, I think that there are ways of improving the performance. Could you please detail your api design and implementation a bit more for us?

Br,
Leo

Answer 2

Hi,

Can I say that Logic Apps is more recommended for a scheduler job?

The workflow of my API including :

• validation of the existence of field records against SQL database (which I built by a nested Logic Apps)
• execute few custom function apps which to convert value from xml to json format, to convert value to md5 format
• connect to HTTP to run a API which hosted in API management where I imported a SOAP web service to transform to REST API
• there are SQL stored procedure need to be executed to insert and select records (which our SQL database is running in VNET and we use ISE to connect)

Thanks.

Answer 3

Hi,

Well, you have 1s on the "Check valid API NAME", and then 710ms is the sum of all the other actions, including overhead.

Seems reasonable, I guess.

Br,
Leo