To answer your questions,
1, 2, 3, 8. Have almost none experience in setting up and running dotnet in Linux environment so far so I prefer windows servers to host and run any dotnet application. Haven't seen performance comparison between running nopCommerce on Windows vs Linux but all of our client's websites are fast enough with almost 80+ google page speed ranks even in case of complex pages and 90+ in most cases.
4. Of course, MS-SQL is faster compared to MySQL for large production databases and there's one more reason, MS-SQL runs perfectly on Microsoft eco-system. Moreover, if you have a large catalog or complex search requirements, you cannot rely only on any RDBMS storage for website speed. You have to use something like Lucene or Sphinx.
5. Anything above Windows server 2019 because we have observed that the newer dotnet versions, specially post dotnet 5 doesn't perform very good on windows server 2016 or earlier versions.
6. Both are good, but when using 2.2 you just need minimum 4 core CPU when running under 5000 products with 100 live sessions or around 8 core CPU if you are somewhere between 10000 - 25000 products with 500-800 sessions. You can increase CPU as needed. While 3.4 could make 20-30% difference.
7. I strongly suggest and prefer using NVMe. HDD is probably out of picture now-a-days and SSD will be almost half performing in a real environment.
9. Always choose latest. SQL Server 2022 in this case.
10. Of course, 4.60.5 is the best one if I talk from new dotnet family but if you are looking for something from dotnet framework then go for nopCommerce 3.90 but it's almost 6 years old.
Moreover, you forgot asking about RAM which is very crucial when talking about nopCommerce or any eCommerce platform because all of these applications uses a lot of caching to serve a lot of content. Even if you use Redis cache, or server memory cache, you need RAM. Please consider at least 12 GB RAM for approx 10000 products with 100-500 live sessions.
BTW, I usually buy VPS from Contabo and choose best suitable configurations based on my past experience with over 800 nopCommerce projects so far :) I hope this helps.
Best regards,
Atul
1, 2, 3, 8. Have almost none experience in setting up and running dotnet in Linux environment so far so I prefer windows servers to host and run any dotnet application. Haven't seen performance comparison between running nopCommerce on Windows vs Linux but all of our client's websites are fast enough with almost 80+ google page speed ranks even in case of complex pages and 90+ in most cases.
4. Of course, MS-SQL is faster compared to MySQL for large production databases and there's one more reason, MS-SQL runs perfectly on Microsoft eco-system. Moreover, if you have a large catalog or complex search requirements, you cannot rely only on any RDBMS storage for website speed. You have to use something like Lucene or Sphinx.
5. Anything above Windows server 2019 because we have observed that the newer dotnet versions, specially post dotnet 5 doesn't perform very good on windows server 2016 or earlier versions.
6. Both are good, but when using 2.2 you just need minimum 4 core CPU when running under 5000 products with 100 live sessions or around 8 core CPU if you are somewhere between 10000 - 25000 products with 500-800 sessions. You can increase CPU as needed. While 3.4 could make 20-30% difference.
7. I strongly suggest and prefer using NVMe. HDD is probably out of picture now-a-days and SSD will be almost half performing in a real environment.
9. Always choose latest. SQL Server 2022 in this case.
10. Of course, 4.60.5 is the best one if I talk from new dotnet family but if you are looking for something from dotnet framework then go for nopCommerce 3.90 but it's almost 6 years old.
Moreover, you forgot asking about RAM which is very crucial when talking about nopCommerce or any eCommerce platform because all of these applications uses a lot of caching to serve a lot of content. Even if you use Redis cache, or server memory cache, you need RAM. Please consider at least 12 GB RAM for approx 10000 products with 100-500 live sessions.
BTW, I usually buy VPS from Contabo and choose best suitable configurations based on my past experience with over 800 nopCommerce projects so far :) I hope this helps.
Best regards,
Atul
Thank you very much! You are the best in answering this topic!
I will use all your advices in setting my new store.