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.
Hi, you should test this site on Servebolt. Servebolt provides databases that are a multiple of times faster than anything you have tried before. We’d be happy to set up a free test. Contact us at firstname.lastname@example.org or through chat and we’ll have a duplicate of the site up and running in no time.
Large databases are not a problem if databases are fast. WordPress postmeta table is not a perfect fit for those data, but it can work much better than you currently are experiencing. Try this site using our databases/servers, and all problems will be history.