Optimizations to index a million WooCommerce products
We have more than a million products, and so temporarily upgraded the RAM and CPU to 64 GB RAM and 16 CPU.
However, I need your help in defining the right or maximum values in PHP and FPM settings.
Please let me know if I need to optimize any value for a quick indexing on an Elasticsearch host.wpsolrKeymaster
If your performance is about indexing, you’ll have 2 factors to consider:
Indexing requires extracting data from WP SQL database. It requires essentially SQL performance.
As you are hosted, a few hundreds of seconds are lost each time you send a batch of documents to index.
You can consider increasing the batch size while indexing. But it can then drain more resources from WordPress.
I just increased the Memory limit to 60 GB on 64 GB RAM server and as of now, I am getting a speed of 1,000 per minute. I hope it will be completed by tomorrow.
Meanwhile, please let me know how to test the imports. I can see a total of 20,000 products imported.
You must be logged in to reply to this topic.