pantonis wrote:1. How do I store images on file system?
Admin -> Configuration -> Settings -> Media Settings. In the "Common" section, "Pictures are stored into..." should be File system instead of Database. You can change it anytime to Database in future.
pantonis wrote:2. "in that case you can upload near about 50,000 - 100,000 products in this database as per my calculations" What about orders. Does this estimation of yours includes orders?
If you talk about records in database that would be a single row with some rows in other tables too. For example, if one record including its hold in other tables is not much complicated, then what space it would take? Few kb's..
Based on that, I estimated that almost you can store 100,000 products in Database and may be many orders too. In some cases, I have seen more than 10,000 orders and around 500-1000 products and other info as well just reached around 2-3 GB in whole database size..
pantonis wrote:3. I already own some Contabo machines but they don't offer SQL Server services. You have to purchase a VPS or physical server and install sql server yourself (free SQL Server Express) whereas in Azure sql server can be purchased based on DTU's and size of the database.
Yes. But to start with I think you can also use SmarterASP services as well or use your own VPS if you want to cut down costs. Azure or any other cloud will be costly in terms of RAM and DB.
NopCommerce RAM usage are high sometimes.. It consumes around 1 - 2 GB RAM in some scenarious..
Thank you,
Atul