Is it possible to optimize the work of an online store on Woocommerce?

Question

WordPress

Friends, tell me. We raised the site on Woocomerce, downloaded 91 thousand products. The site is on a dedicated server, but the database still started to go down.

The server has an out-of-memory problem. Turns on OOM Killer and forcibly terminates mysqld

Server on the run, not bad.
CPU: 2RAM: 2 GB SSD: 30 GB The

question is, how does WP feel in general with so many products? is it possible to optimize it, talked to the programmer, says that WP, in principle, does not pull such a quantity of goods. Is it so?
If someone raised such a quantity, how did you optimize the work of such an assortment? Thank you.

Answer 1

https://docs.woocommerce.com/document/woocommerce-...

What is the maximum WooCommerce can handle?
Sky is the limit. We've seen instances of shops with 100,000+ products listed, handling thousands of transactions per minute. In those cases, they had great hosting support and their own developer team focused on optimization.

Check the optimization, I'm sure that everything is not so good there.