WordPress.org

Ready to get started?Download WordPress

Forums

Groups
[resolved] Performance Issues with Groups + WooCommerce + WPML (4 posts)

  1. Jesse Aaron
    Member
    Posted 2 years ago #

    Greetings!

    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!

    WordPress 3.4.1
    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.

    http://wordpress.org/extend/plugins/groups/

  2. itthinx
    Member
    Plugin Author

    Posted 2 years ago #

    Thanks for your detailed report on the issue jaaron, I'll need to have a look, test and get back to you on this.

  3. itthinx
    Member
    Plugin Author

    Posted 1 year ago #

    I contacted WPML and commented this, asking to get access to their plugin to evaluate the issue. Will get back with findings ...

  4. itthinx
    Member
    Plugin Author

    Posted 1 year ago #

    I've run some tests and use the P3 profiler to get a quick overview of results.

    All tests done on WP 3.4.1 (Twenty Ten theme) :

    Plugins active other than P3:

    A)

    - Groups
    - Sitepress Multilingual Cms

    Plugin Load Time: 0.377
    Plugin Impact: 55.7%
    MySQL Queries: 92

    B)

    Groups
    Groups WooCommerce
    Sitepress Multilingual Cms
    WooCommerce
    WooCommerce Subscriptions
    Wpml String Translation
    Wpml Translation Management

    Plugin Load Time: 0.786
    Plugin Impact: 73.1%
    MySQL Queries: 123

    C)

    Groups
    Sitepress Multilingual Cms
    WooCommerce Multilingual
    WooCommerce

    Plugin Load Time: 0.733
    Plugin Impact: 69.9%
    MySQL Queries: 151

    D)

    Groups
    Groups WooCommerce
    Sitepress Multilingual Cms
    WooCommerce
    WooCommerce Multilingual
    WooCommerce Subscriptions
    Wpml String Translation
    Wpml Translation Management

    Plugin Load Time: 0.807
    Plugin Impact: 73.0%
    MySQL Queries: 147

    E) (repeated as in C)

    Groups
    Sitepress Multilingual Cms
    WooCommerce Multilingual
    WooCommerce

    Plugin Load Time: 0.727
    Plugin Impact: 69.9%
    MySQL Queries: 151

    It doesn't look like anything is causing an important increase in the number of MySQL queries but that if something is causing a huge increase, it might be related to the number of posts on the site. The test site used for the above has 4 posts (and 4 translations) and 1 additional language enabled.

    Suggestions:

    What I would suggest for the site you're seeing the issues on is to run P3 as well and post your results so we can see what might really be causing the performance impact.

    Did you try to use a caching plugin and optimize the server settings? There's a lot of factors that can contribute to your issues, including PHP memory limits, available memory for your web server ...

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic