- This topic is empty.
February 3, 2018 at 6:48 pm #266253alias3729Participant
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.February 5, 2018 at 3:13 am #266267serveboltParticipant
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 @servebolt.com">firstname.lastname@example.org or through chat and we’ll have a duplicate of the site up and running in no time.February 6, 2018 at 2:12 am #266295grimslayerParticipant
I think the problem may be that your site is not best suited for wordpress.
Moving over to a different system will definatly help out along with getting yourself onto a decent server.
I am pretty sure an API will exist for car parts so that you do not have to list every category on the site itself.February 6, 2018 at 5:02 am #266298serveboltParticipant
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.
- The forum ‘Back End’ is closed to new topics and replies.