My sql query starts too slow. What happend in my service?
I use app service in azure.
I use django and postgresql to build the system. And I deployed it with azure app service.
In my local development system looks ok. It just took 20ms to complete the same request.
But in the azure It looks serious.
It starts the database query after 300ms.
I don't know what is the problem.
Couldn't Gunicorn start the process? or Couldn't it get the connection from the postgresql?
or Did web service delay my service? (Wasn't ASGI Or WSGI supported in azure web server?)
Is there any specific information to analyze this problem?
Insights is very nice tool but I couldn't get any further information.
Hi, @라이트비전 주식회사 Welcome to the Microsoft Q&A forum, and sorry for the trouble you are facing.
As we understand you are facing query slowness after your deployment to the Azure app service and you used Django and PostgreSQL.
It would be difficult to look into this issue remotely for us if you have a support plan I would suggest you raise a support ticket and an engineer from the support team can check the root cause. Please let us know if you face any issues with the support ticket and we can pitch in.
Hi, @라이트비전 주식회사 We haven't heard back from you. Just wanted to check if you are still facing the issue?
Sign in to comment