Using Azure Function to retrieve data from SQL DB

Question

I have currently a WebAPI which has a GET method that reads 10,000 rows from a SQL Database and process to create a JSON object. I use Azure App Service Plan to host this WebAPI.

My question is, is Azure Function App a suitable platform to host the business logic which the WebAPI currently does by considering the amount of data retrieved and the processing has to be done.

functions should run fast, and wait for the 10k rows to be generated probably will timeout — Thiago Custodio
– Thiago Custodio, Commented Jun 8, 2020 at 13:18

caiyi Ju · Accepted Answer · 2020-06-09 02:28:39Z

1

I think Azure function is a choice for you as it is designed to architect serverless solutions. And in the Azure function document there is similar scenario as yours.

Also, just like @ThiagoCustodio mentioned in the comment, you still need to consider the function app timeout duration. Here is a reference of timeouts regarding different hosting plan.

Reference:

Optimize the performance and reliability of Azure Functions

answered Jun 9, 2020 at 2:28

caiyi Ju

15.8k3 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using Azure Function to retrieve data from SQL DB

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related