Home > OS >  Entity Framework startup time slow against SQL DB on Azure
Entity Framework startup time slow against SQL DB on Azure

Time:12-31

I am having an issue, and I am not sure where to start. I have a Windows Forms application which utilizes EF 6 database-first. Now when starting the application with a database served locally on the same machine, the application starts up in around 5 seconds. But with the same database on Azure, the application takes up to 40 / 50 seconds to start up.

The database is hosted in Europe and I looked at the scaling - none of the resources are utilized 100% when starting up the application.

I am really struggling to find an idea where to start looking - but this is really a problem. I tend to think, that when migrating from Azure D (Germany hosted Azure) to global Azure, the problem got much worse - but I have been procrastinating the problem, so I cannot tell.

Do you guys have any hints on where to look into?

Thanks in advance!

CodePudding user response:

Thank you all for your help. Turns out, there was a second connection string that I did not see. So the application tried to connect to an non-existing database until it got a timeout. When fixing this, the applications startsup like a breeze!

Don't know, why I did not find that out, while debugging. Thanks for you help!

  • Related