We have issues with very slow operations related to managing products, orders, posts. After numerous server optimizations and still not results, we have decided to try the "Scalability Pro" plugin.
We have enabled most of the features, but not improve the speed at all. The odd thing is the Query Monitor did not show slow queries, but still a product save or publish can take more than a minute.
Any further assistance will be highly appreciated.
I’m seeing sub 1-second speed on WooCommerce > Orders and Products > All Products.
Your slow save could be a number of things.
- Are you using MyISAM instead of Innodb? I checked, you’ve get innodb for every table except wpvey2_wpforo_phrases
- What is hooked onto save product? It might be recounting all the terms – you can defer term counting until night time in settings of scalability pro
- Are there other things hooked onto save product? Do you notify 3rd party services? Maybe you send emails somewhere? If so, these things often have a timeout of 30 seconds so I’ve seen before failing emails adding 30 seconds or a minute to the Save Product button (depends if the code tries to email once or twice)
Note: That’s quite a hard thing to debug since the ‘save product’ or ‘publish product’ button does stuff in the backend and THEN shows the next page, so you don’t see any of its activity in Query Monitor. If you can create a dev clone of your site then we could run xDebug on the Save Product button to find out everything that happens. You could also perform a grep through your source code to find which plugins or custom functionality is hooking onto the Save Product button. If you SSH to your server, then change directory to your plugins folder then you can run this to find plugins that add to the save product hook: grep “‘save_post'” . -R -l
Then repeat this inside your wp-content/themes folder to search your theme and child theme.