I am working on a WooCommerce site that’s just massive. It has over 160,000 products in 45,000 categories. It’s for makes, models, and years for cars, trucks, semi’s, boats, farm equipment, construction equipment, pretty much anything with a motor, so the categories count is essentially unavoidable. The problem I’m having is two fold. First, the postmeta table is just massive, bordering on 6 million records.
We have Varnish and WP Rocket installed so the front end is fairly ok, but this along with the number of categories (the second problem) can’t be helping any. They are complaining about the admin add/edit product screen is very slow, taking 30 seconds to a minute to load. They edit product photos and prices all the time, so this could be problematic. I’ve installed Liquid Web’s plugin to put the order data in custom tables instead of postmeta, but I haven’t been able to find a way to do this with the products.
Is there anything that can be done to make the product add/edit screens load faster? Using WP 4.9.2 with Woo Commerce version 3.2.
