I have a fairly small database ~200MB which when running in the web edition of SQL azure is lightning fast. I've switched it to the basic edition and all of a sudden a group of queries which took less than 1 second to execute is now taking ~25 Seconds (running in basic mode) Switched it to a D1 and the halved the speed to 12.5 seconds.
Running on premise with an average server and the query took ~1 second.
In both tests I was the only one using the database. I'm shocked that it's running so slowly. I know the new databases work slightly differently but was really shocked at the performance difference.
Does anyone have any good suggestions on how to optimise your database design to improve performance when running in SQL Azure.
If anyone has any suggestions for me to check I'd love to hear it. I'm figuring that it's the amount of queries which it's executing in one hit.
I'm about to create a view to do all the querying in one hit. Something that I've already run on the database and on the basic edition it's instant.
This is only a little test app so it's easy for me to alter but i'm concerned about our productions apps which may suffer from the same issue.