Hi Umbraco, we are experience latency issues running Umbraco v15.2.2 locally with the database hosted on Azure (high spec) When doing anything in the CMS like editing a page, saving publishing, it is taking 10-15 seconds to call the management API. Running the WebApp on Azure (so Azure to Azure) works fine. Also, previous versions of Umbraco (v13 for example) are working perfect in the same environment of local IIS connecting to Azure SQL DB. The only issue is local IIS connecting to Azure database on v15 Is there a config setting we are missing or a know issue we don't know about?

15 is newer dotnet so you may be affected by modern SQL stuff like server certificate verification, modern transport encryption, Entra sign-in, Azure Arc enablement etc. Try experimenting with the connection string to make sure you're going directly to the database with the simplest sign-in method. Also, use SSMS or Azure Data Studio as a reference to see if it's equally slow there.

Thanks for the adivce , we will investigate these ideas

I'm not 100% on this as haven't tested v15 in anger, but could this be down to the caching changes? Where I live, I have slightly higher latency than my colleages in the city and I've never been able to reliably use Azure SQL while running Umbraco locally, while they use it all the time - It's nothing to do with the spec of the azure database - just that Umbraco is quite chatty in certain scenarios and even an extra 10ms in each SQL query makes a noticeable difference to performance.

I can relate. I've used Sitecore, which is probably even more Database-chatty than Umbraco. When using a remote database compared to a local database, the latency went from < 1ms to like 6ms. It's still fast, but it's more than 6 times slower and with the number of database calls that made it unreasonably slow and useless for development

In its defense, Sitecore has so many other qualities that make it useless for development that the database latency issues are negligible.

lol! Amen 😛