Microsoft Azure Data loads slowly when developing locally

Question

We have Microsoft Azure App Service Plan. We already using system at domain. We don't have any problems when we are using at domain. If we want to do the development on the local computer, it is very slow to pull the data from the database.

Answer 1

AtalayGven-9781, Firstly, apologies for the delay in responding here.

Just to clarify and to better assistance you on this issue (add pertinent tag/SME), we need some more information:
When you say, “We don't have any problems when we are using at domain” and “it is very slow to pull the data from the database” – Does it work fine on Azure WebApp/App but not on a test Application on the local server? How exactly are you testing this? Do provide more information about your setup/requirement?

There could be several reasons for slow performance, including proximity (app and DB in the same* region) and connection efficiency, etc. Kindly take a look at this document for some pointers.
Best practices for building an application with Azure Database for MySQL

To begin with, enable and analyze query logs to fetch more details. The slow query log can be used to identify performance bottlenecks for troubleshooting.

-Also, leverage the ‘Performance Recommendations’ feature analyzes your databases to create customized suggestions for improved performance.

• To produce the recommendations, the analysis looks at various database characteristics including schema. Enable Query Store on your server to fully utilize the Performance Recommendations feature.