Help with customized WooCommerce site
-
I work for a store that uses a heavily customized WooCommerce site for in-store sales: The site runs on a private intranet (hence no link available, sorry) and is responsible for entering orders, taking payments via a separate Poynt cardreader, and then saving data for our in-house inventory database. It’s been in operation for four years and has around 180,000 orders in it.
Of late, the system has been slowing down drastically, and some larger queries seem to be failing completely. Nothing has been changed recently in the code that might affect these queries, so I think I’m looking at a database-speed issue. (wp_posts is just under 100MB, while wp_postmeta is at 2.1GB and climbing.) I’d like to try this plugin and see if it helps with these issues, but first I need to know: does this plug-in do anything that might mess up the customized plug-ins we use with the site?
-
Thanks for the question.
Maintaining the keys on database tables is a routine operation on large applications in busy datacenters, and that is what this plugin does. It corrects some legacy ineffiencies in WordPress’s database definition.
Can I promise it doesn’t interact poorly with your custom plugins? No. But I have not heard of adverse interactions with plugins unless they also alter database keys.
If you use WooCommerce with that many orders and you use HPOS, version 8.9 contained a serious performance regression, making it take forever to render the order page. It was partly, but not totally, fixed in WooCommerce 9.0. I have a free open source plugin to fix it completely. You can find an explanation here. https://www.plumislandmedia.net/wordpress/plugin/fast-woo-order-lookup/
- You must be logged in to reply to this topic.
