Slow query

  • jmorti

    (@jmorti)


    4 years ago

    I’m getting a slow query on the admin dashboard from the plugin. Here is the offending query:

    SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month
    FROM wp_posts
    WHERE post_type = ‘attachment’
    ORDER BY post_date DESC

    I’m not sure why it’s running there but does anyone have any idea how to fix it? We have a lot of comments. Thanks.

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