[Plugin: Groups] Groups making thousands of queries per page view

  • russnem

    (@russnem)


    10 years ago

    The Groups plugin makes over 1,000 queries per page view. In fact, it makes one db query for every “page” post type in the wp_posts table, on every page view. We have over 1,000 pages on our site.

    This happens immediately after the theme calls get_pages() and before the theme calls get_options(). The query text is:

    SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (8181)
ORDER BY meta_id ASC

    The stack trace is:

    update_meta_cache()-
    get_metadata()
    get_post_meta()
    Groups_Post_Access::get_read_post_capabilities()
    Groups_Post_Access::user_can_read_post()
    Groups_Post_Access::get_pages()
    apply_filters(‘get_pages’)
    get_pages()
    of_options()
    do_action(‘init’)

    Unfortunately the plugin author thus far has not been willing to offer any guidance on how to remedy this. He’s been quite silent, in fact. That means that we’ve had to stop adding pages because every time we do, the Groups plugin makes our site slower.

    @itthinx Please offer any details or plans you have to fix this bug.

    Does anybody have a work around they’ve been successful with?

Viewing 2 replies - 1 through 2 (of 2 total)

  • Followed the bounce-around from thread to thread on this issue. Have you found a solution? And if not, then have you found a viable alternative?

    I stumbled across this, looking for more clear answers to a different issue I was having (most of the “documentation” talks of how to click one menu button and then voila! look what happens! And click another option and tadaa! As opposed to clearly addressing various issues and obvious concerns. Anyway, since I was testing this out on a staging server, I did not run into any speed or query issues, but glad I came across your “conversation” before it was live.

    I’d love to know about any other alternatives to this plugin, as I’m running WooComm+Sensei and need all kinds of access control to products, pages, post, courses, content in general, etc. and other things.

    Piecing together plugin + plugin to get the desired end-result stinks, as there’s plugin-conflicts, versioning, support, integration, flexibility, bloat and all sorts of issues. But unless you can deal with all kinds of SQL, API’s, J-whatever and all sorts of things…then it’s what you’re stuck with. ??

    Trying this combo:
    WooComm’s Catalog Visibility Options + Multiple Roles + add_role (); functions in functions.php. Looks like it will do, at least, what I need – without all the extra fluff and a minimum of headache.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Plugin: Groups] Groups making thousands of queries per page view’ is closed to new replies.