Thanks for reaching out! If you're handling around 22,000 API requests daily with an SQL database, the Consumption Plan could be a cost-effective choice. It automatically scales and charges only for the resources used, making it ideal for unpredictable workloads.
However, if your usage is more steady and predictable, the Elastic Premium Plan might be a better fit. It offers lower latency, better performance, and virtual network integration, ensuring consistent execution times.
Regarding execution time, it depends on the complexity of your API calls and database interactions. If each function takes around 2-5 seconds, you can estimate the total runtime based on your request volume.
For pricing, the Consumption Plan charges based on execution count and duration, while the Premium Plan has a fixed monthly cost based on allocated resources. To get a precise estimate, you can use the Azure Pricing Calculator. It allows you to enter your expected execution count, duration, and memory usage to compare costs across different plans.
References: