slow queries in wp dashboard

  • Resolved Marty

    (@bozzmedia)


    3 years ago

    We have a large site (25,000 posts, 400,000 comments) and have been logging slow queries on the dashboard side with this plugin activated using Query Monitor

    SELECT SQL_CALC_FOUND_ROWS DISTINCT wp_posts.*, IF (wp_posts.post_type = 'tribe_events', wp_postmeta.meta_value, wp_posts.post_date) AS post_date
FROM wp_posts
LEFT JOIN wp_postmeta as wp_postmeta on wp_posts.ID = wp_postmeta.post_id
AND wp_postmeta.meta_key = '_EventStartDateUTC'
WHERE 1=1
AND wp_posts.post_type IN ('post', 'page', 'attachment', 'rl_gallery', 'tribe_venue', 'tribe_events')
AND ((wp_posts.post_status = 'publish'))
ORDER BY post_date DESC
LIMIT 0, 100	

    WP_Query->get_posts()
    wp-includes/class-wp-query.php:3111
    WP_Query->query()
    wp-includes/class-wp-query.php:3542
    WP_Query->__construct()
    wp-includes/class-wp-query.php:3653
    UAGB_Admin_Helper::show_rating_notice()
    wp-content/plugins/ultimate-addons-for-gutenberg/classes/class-uagb-admin-helper.php:160
    UAGB_Admin::register_notices()
    wp-content/plugins/ultimate-addons-for-gutenberg/classes/class-uagb-admin.php:153
    do_action('admin_init')
    wp-includes/plugin.php:474

	Plugin: ultimate-addons-for-gutenberg

    Takes almost 2 seconds of query time.

    This seems to be running on every single admin page, slowing down the backend dramatically. There may also be an issue with this plugin and The Events Calendar plugin based on the query info here, ultimately the issue goes away when I have UAGB deactivated.

    Any insight here? Can this plugin be developed as to not load on every /wp-admin/ page? Thanks

    • This topic was modified 3 years ago by Marty.
Viewing 4 replies - 1 through 4 (of 4 total)

  • Hello @bozzmedia ,

    We’re sorry for the inconvenience caused to you.

    Also, we are thankful for your patience and readiness to help us fix things that we come across.

    I’d like to let you know, we have reported this issue to our concerned developers. They are looking into it. Please lend us some time. It will be fixed in our upcoming updates.
    ?
    Your patience and co-operation are highly appreciated.

    Thread Starter Marty

    (@bozzmedia)

    I appreciate your response and attention to this. Thanks!

    Hello @bozzmedia

    Thank you for your patience. Our developers are still working on this case and have yet to reach a conclusion. Please do not worry, I will continue to follow up with them. I will update you as soon as I hear from them.

    I appreciate your patience and understanding in this matter. Have a good one!

    Regards.
    Judith

    Hello @bozzmedia,

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Thank you!

    Regards.
    Judith.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘slow queries in wp dashboard’ is closed to new replies.