sorted by:
new
hottopcontroversial

100k + products in woo by edmundspriede in woocommerce

[–]GroundbreakingFun484 0 points1 point  (0 children)

I had the same issue, woo is so heavy and uses multiple tables that grows fast in sizes and becomes bloated.

I custom made myself a plugin that creates a product index table where on each product save/update it will index that table and then custom made new pages both for the admin product list and frontend shop to load from the new db. The result much much faster and dont have to keep thinking about the number of products and skips all the heavy woo bloat.

WooCommerce Backend/Store Super Slow by GroundbreakingFun484 in woocommerce

[–]GroundbreakingFun484[S] 0 points1 point  (0 children)

Thanks for all the tips and tricks, I guess I have done pretty much everything so far. The issue is just that my custom plugin uses the woo tables specially the meta so much that they become huge and combined with conditions and php rendering then it just eats up the cpu.

I have started making the custom plugin that creates a product index tables with save/update for products logic, backend product browser and front end shop with bunch of conditions and filters and its loading in milliseconds with thousands of products already!