I create azure web app in west europe and azure sql database in west europe. When app connecting to sql database and execute simple select it takes 4 sec (even in local cheap hosting it takes 200-300ms). Its horrible. I create MySQL clear db and the same problem, horrible latency. The both services are in the same datacenter, why it takes so long time? How to fix it?
1 Answers
0
votes
First what you can try is to scale your pricing plan on database server and App service. Besides, Azure has build in tool - Database Advisor, which can help you to fix your possible db issues (like add index). Finally - check out database metric (there is possibility to edit chart) to know for sure that this is network or db latency.
