Azure Function App & Postgre connection letency

Amit Kohli - B 1 Reputation point
2021-11-15T11:02:30.73+00:00

One of our function app configured to retrieve data from Azure postgre single server database using Python libraries.

Here function app is running as expected, However, we could notice - whenever function app tries to connect with Postgres it will take more then 250 MS just for connection.

So anybody please suggest any area which can be looked or improved.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,400 questions
Azure Database for PostgreSQL
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Pramod Valavala 20,656 Reputation points Microsoft Employee
    2021-11-15T17:23:01.497+00:00

    @Amit Kohli - B The first-time connection would take time to establish and get ready for queries. The recommended best practice is to re-use clients in your function app across invocations.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.