[Resolved] Performance Issues with Groups WooCommerce WPML
Great job with the functionality of this plugin, it’s exactly what I’ve been looking for! I’m pretty new to WordPress so bear with me if I don’t have all of the right ways of evaluating things but what I’m seeing is when I have Groups enabled with Groups WooCommerce extension + WooCommerce + WPML, the main English site loads a bit slower (maybe to be expected), but the other languages load like 100x slower, so much that they completely time out, max out my CPU and sometimes crash my server, all with just a single page load (like the home page). When I disable Groups the slowness goes away everything is back to normal (disabling just Groups WooCommerce has no effect on slowness).
I’m new to figuring out how to troubleshoot performance in WordPress so apologies if this isn’t the best method. I tried logging slow queries in MySQL but nothing was taking a second or longer. I also tried enabling the general query log in MySQL and found that for the non-English page loads, I was getting an unusually large number of queries that seem to be related to the Groups plugin (hence why I’m posting this here rather than WooThemes or WPML support channels). Here is what the queries look like:
38 Query SELECT capability_id FROM wp_groups_capability WHERE capability = 'manage_options' 38 Query SELECT * FROM wp_groups_user_capability WHERE user_id = 0 AND capability_id = 8 38 Query SELECT capability_id FROM wp_groups_group_capability WHERE capability_id = 8 AND group_id IN (SELECT group_id FROM wp_groups_user_group WHERE user_id = 0) 38 Query SELECT COUNT(*) FROM wp_groups_group 38 Query SELECT group_id FROM wp_groups_user_group WHERE user_id = 0 38 Query SELECT * FROM wp_groups_capability WHERE capability = 'manage_options'
So to load a single page in French (in this case, the home page), that exact set of queries runs thousands and thousands of times. I can’t say for sure whether that’s the cause of my slowness but when I watch the MySQL General log while the page is loading and eventually times out, those are the only queries I can see flying by so it feels like a safe assumption.
I’d be greatly appreciative of any advice you could offer for how to further troubleshoot this issue, thanks!
Groups 1.2.3 (just upgraded and tested again to make sure, still an issue with 1.2.3)
Groups WooCommerce Version 1.1.0
WooCommerce Version 1.5.8
WooCommerce Subscriptions Version 1.0
WooCommerce Multilingual Version 1.2
WPML Multilingual CMS Version 2.5.2
WPML String Translation Version 1.4.0
WPML Translation Management Version 1.3.1
I have WPML configured to use a different subdomain for each language. Also, I’ve seen on other forum posts that the WPML guys are generally open to give plugin developers a free copy of their plugins for interoperability testing purposes.
- The topic ‘[Resolved] Performance Issues with Groups WooCommerce WPML’ is closed to new replies.