- Premium
October 10, 2022 @ 10:43 amHellow, 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;
October 10, 2022 @ 12:09 pmHi Eloi,
Thanks for using our plugins.
If your server has problems with slow queries, we recommend the following:
1) Switch off the ‘Analytics’ feature:
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.
The topic ‘Slow query’ is closed to new replies.
