Performance Tips For 500k Products

I have an nopcommerce fashion website version 4.5.
Db: MSSQL 19
Server: Windows Server 22
What can I do for best performance.

Thanks.

1. Use compressed images or use any cdn plugin for your resources.
2. Keep product simple. Use less product attribute, tier price,etc..
3. Single store on a server

Addtion: 4GB ram and more or equal to dual core processor

OrhanAykac wrote:
As you are using version 4.5 and lot of performance has already been optimized. After that, you can do some fine-tuning.  If your shop is a single language, a single currency, and a single store. Then there are still some changes that can be done for performance optimization. Also if possible move away from SQL-server to postgresql.

https://www.nopcommerce.com/en/common-tips-settings-recommendations-to-optimize-performance-in-nopcommerce

Thanks for all your advice.