Slow queries

  • Resolved arihantk09

    (@arihantk09)


    11 months, 3 weeks ago

    The plugin is taking long time for queries and making the website very slow, almost the website died, is there any solution for the query?Below are the details

    SELECT?tr.object_id?AS?objectId, tt.term_id?AS?parentId, p.post_type?AS?type
    FROM?wp_term_relationships?AS?tr
    LEFT?JOIN?wp_posts?AS?p
    ON?(tr.object_id = p.ID)
    LEFT?JOIN?wp_term_taxonomy?AS?tt
    ON?(tr.term_taxonomy_id = tt.term_taxonomy_id)

    UserAccessManager\Database\Database->getResults()

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author GM_Alex

    (@gm_alex)

    Please try the caching settings. Since of the logic of the plugin I cannot do much to speed this up expect caching.

    Thread Starter arihantk09

    (@arihantk09)

    Actually I further debugged the issue and enabled the caching as well, I checked the server load before activating the plugin and after activating the plugin, there was a major hike in the server load. What could be the reason, its not only the query, its something in the background which is adding load to the website, can you please quote on this?

    Plugin Author GM_Alex

    (@gm_alex)

    The plugin recursively resolves the dependencies of the access so, depending on the number of posts etc., it can be heavy. I would recommend using the php caching if your server has enough ram. Also if you are developer and find some improvements feel free to make an MR at github.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Slow queries’ is closed to new replies.