Slow queries

  • Resolved arihantk09

    (@arihantk09)


    2 years, 7 months 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)

    2 years, 5 months ago

    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)

    2 years, 5 months ago

    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)

    2 years, 5 months ago

    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.