rkotulan wrote:Any updates on this? I've just moved our nopCommerce website and database to Azure Web App, Azure SQL and blob storage. And performance is extremely poor, had to go into upper Premium tier for the database (700 USD/mo) to get acceptable load times around 1,5 sec, today on a dedicated server with IIS and SQL server on the same load time is less than 1s.
Hi mgustafsson,
Why did you decide to move to Azure? How many products do you have in store? On which page do you measure load time?
I recently made load test on our shop with 150000 products.
Test environment
dedicated server Xeon E3-1230 V5 3,6 GHz
RAM 16GB, SSD
I used
https://loader.io and I measured acces to category page and one product page.
I got 1.7s avg load time. 1 user per sesc.
Please share your experience and measure methodology.
Best regards,
Rudolf
Basically for the ease of DevOps - we are about to outgrow our current (dedicated) server and would like to easily be able to scale out and up when needed, also Azure's continuous delivery seems like a nice fit for us.
We have 50K products and around 350 categories. So far I've only looked at the load time of the home page in Chrome dev tool - at first the results were very poor. However after creating nonclustered indexes on GenericAttribute (EntityId, KeyGroup) and Customer (CutstomerGuid) tables the pressure on the database seemed to decrease dramatically.
I'm now on Azure's S0 Standard (10 DTUs) price plan and the site seems to load as fast as on the dedicated server. Before creating the indexes I had to be on the P2 Premium (250 DTUs) plan in order to get decent load times.
I have also set up a SQL Server VM in Azure as Greg Smyth suggested and going to run a some stress tests later this week to determine the best setup for us. I'll get back when I have those results.
(Edit: We are on nopCommerce 3.7)