Support » Plugin: PixelYourSite - Your smart PIXEL (TAG) Manager » Slow query (pro version)

  • flofr

    (@flofr)


    Hello,

    Plugin version PRO – version : Version 7.1.6

    I find out that your plugin slow down my website. I investigate and your plugin made some slow query (like very slow).
    Here is one of them :

    SELECT wp_posts.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )LEFT JOIN wp_term_relationships tr ON wp_posts.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tt.term_taxonomy_id=tr.term_taxonomy_id INNER JOIN wp_terms t ON t.term_id = tt.term_id WHERE 1=1 AND ( ( wp_postmeta.meta_key = '_pys_event_state' AND wp_postmeta.meta_value = 'active' ) ) AND wp_posts.post_type = 'pys_event' AND ((wp_posts.post_status = 'publish'))OR (t.name LIKE '%XXX%' AND wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC;

    Do you know, how to fix it?

    Thank you by advance

    • This topic was modified 4 months ago by  flofr.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author PixelYourSite

    (@pixelyoursite)

    Hi,

    This forum is strictly for the free version (WordPress rules). You can contact us on our website with more details about your problem.

    flofr

    (@flofr)

    Ok, sorry.

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.