Recently I needed to improve the performance of a WooCommerce installation with multiple 10,000 products. On regular WordPress pages, performance was already good – the performance issues occurred on product archive pages. The post »What does it take to scale WooCommerce?« by Chris Lema contained the tip to use Elasticsearch, that can be integrated via ElasticPress that also supports WooCommerce. After that, WordPress uses Elasticsearch instead of the MySQL database for querying content.
Read and tested, and the result: a significant improvement of load time, now below one second ⚡
So if you are having issues with load speed on larger installations, where the database seems to be the bottleneck, try using Elasticsearch 🙂