Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Premium
    Image
    October 10, 2022 @ 10:43 am

    Hellow, we have performance problems, and we are investigating what’s happening…

    MySql Monitor, informs that we have one slow query. Can you help us?

    SELECT SQL_CALC_FOUND_ROWS bb_posts.ID
    FROM bb_posts INNER JOIN bb_postmeta ON (
    bb_posts.ID = bb_postmeta.post_id )
    WHERE 1=1
    AND (
    ( bb_postmeta.meta_key = ‘gdpr_uvid’ AND bb_postmeta.meta_value = ‘cc4de32ba6de3bb28824a223a054effc’ )
    )
    AND bb_posts.post_type = ‘gdpr_analytics’
    AND ((bb_posts.post_status = ‘publish’))
    GROUP BY bb_posts.ID
    ORDER BY bb_posts.post_date DESC
    LIMIT 0, 1;

    ImageMoove Agency
    October 10, 2022 @ 12:09 pm

    Hi Eloi,

    Thanks for using our plugins.

    If your server has problems with slow queries, we recommend the following:

    1) Switch off the ‘Analytics’ feature:

    Image

    2) If that doesn’t help, please add the following to your functions.php

    add_action( 'gdpr_cc_prevent_ajax_script_inject', '__return_true' );

    Hope this helps.

     

Viewing 2 posts - 1 through 2 (of 2 total)

The topic ‘Slow query’ is closed to new replies.

MooveAgency - Support Forum
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.