tagskigen

Forum Replies Created

Viewing 3 replies - 1 through 3 (of 3 total)
  • Forum: Plugins
    In reply to: [Block Bad Bots and Stop Bad Bots Crawlers and Spiders and Anti Spam Protection] Slow Loading after Update
    tagskigen

    (@tagskigen)

    5 years, 5 months ago

    Hi Bill,

    I see pretty noticeable changes to the file where that query is made (stopbadbots/functions/functions.php), between 6.06 and 6.14 (the first version where Stefan references experiencing a similar issue). And even more changes when comparing 6.06 with 6.20.

    If it is not that query specifically, there is definitely a change to the way the plugin is logging data that is creating issues. I should be clear that the performance issue was so bad after updating we had to disable the plugin on our production environment, which resolved the issue right away.

    Best,

    Patric

    Forum: Plugins
    In reply to: [Block Bad Bots and Stop Bad Bots Crawlers and Spiders and Anti Spam Protection] Slow Loading after Update
    tagskigen

    (@tagskigen)

    5 years, 5 months ago

    Hi Bill,

    I am seeing several slow queries along the lines of UPDATE wp_sbb_visitorslog SET human = ? WHERE ip = ? since updating to 6.19. Updating to 6.20 I still see duplicate and slow query warnings from this query.

    We do hope to make improvements to the site and reduce the number of AJAX calls, but we had no issues with your plugin and performance before updating (we were on 6.06). This seems consistent with what Stefan was experiencing with newer versions of the plugin.

    I can confirm that the memory limit is not the issue.

    Best,

    Patric

    Forum: Plugins
    In reply to: [Block Bad Bots and Stop Bad Bots Crawlers and Spiders and Anti Spam Protection] Slow Loading after Update
    tagskigen

    (@tagskigen)

    5 years, 5 months ago

    Hello,

    I can confirm this behavior with versions of plugin that have the Blocked Visits Log functionality added. This appears to be an issue on sites with a multiple AJAX calls.

    The functionality that is setup to log users to the sbb_visitorslog table is outside of any WordPress hooks. It appears to be fired not only on every page load, but also every single AJAX request. This leads to slow AJAX calls and overall brings down performance on the site, and sometimes also creates duplicate entries in the Visitors Log for a single page view.

    This is an excellent plugin, and I appreciate all the hard work. I will look forward to an update!

    Thanks,

    Patric

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