Getting Adrotate Pro queries- slowing down site

  • We ran some tests on our site since it was loading slow and discovered that AdRotate-Pro was having some query issues. Can someone please advise me how we can optimize or fix these issues as I love the capabilities of AdRotate-Pro and don’t want to deactivate it.

    This is the message we got when tested:

    Plugin: adrotate-pro

    Query: SELECT wp_adrotate.id, wp_adrotate.tracker, wp_adrotate.weight, wp_adrotate.timeframe, wp_adrotate.timeframelength, wp_adrotate.timeframeclicks, wp_adrotate.timeframeimpressions, wp_adrotate.timeframeimpressions, wp_adrotate.crate, wp_adrotate.irate, wp_adrotate.cbudget, wp_adrotate.ibudget, wp_adrotate.cities, wp_adrotate.countries, wp_adrotate_linkmeta.group FROM wp_adrotate, wp_adrotate_linkmeta WHERE ( wp_adrotate_linkmeta.group = 2) AND wp_adrotate_linkmeta.block = 0 AND wp_adrotate_linkmeta.user = 0 AND wp_adrotate.id = wp_adrotate_linkmeta.ad AND (wp_adrotate.type = ‘active’ OR wp_adrotate.type = ‘2days’ OR wp_adrotate.type = ‘7days’) GROUP BY wp_adrotate.id ORDER BY wp_adrotate.id;

    Time: 0.0013

    Seems it is slowing down the loading of our site. https://www.missomoms.com
    I’m looking for someone who can help me with this issue.

    zooeydog

  • The topic ‘Getting Adrotate Pro queries- slowing down site’ is closed to new replies.

Tags