Expensive Database Queries on all Admin pages

  • Resolved Marty

    (@bozzmedia)


    2 years, 5 months ago

    I have been working on eliminating slow queries and this plugin seems to run very long queries, taking 11 seconds to load on a high powered VPS.

    Part of this appears related to The Events Calendar Events post types.

    Why is this query running on backend pages? I am seeing it even on the Dashboard page. Can it be optional, can I disable that loading? Thank you.

    ———–

    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:3139
    WP_Query->query()
    wp-includes/class-wp-query.php:3586
    WP_Query->__construct()
    wp-includes/class-wp-query.php:3718
    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:151
    do_action('admin_init')
    wp-includes/plugin.php:476

	Plugin: ultimate-addons-for-gutenberg
Viewing 2 replies - 1 through 2 (of 2 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, that I have reported this issue to our concerned developers. They have added a task for it and will start work on it. Please lend us some time.

    Your patience and co-operation are highly appreciated.

    Regards.
    Judith.

    Hello @bozzmedia

    I have received an update from the developers about the issue that this Query runs till 5 posts and does not build using UAG. Once that is done and you can close the notice as it will not run anymore. They have however added a task to their to-do list and they will be working on this towards a resolution. You can expect a fix in the next update of the Astra theme; however, I am afraid that I do not have a timeline for you as of now.

    I appreciate your patience and understanding in this matter.

    So I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

    Regards
    Judith

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Expensive Database Queries on all Admin pages’ is closed to new replies.