Made my admin slow by querying users

  • UPDATED: this query made our admin slow, but the developer has responded with clarifications, will update to 5 stars once optimized.

    Inflicting query:

    SELECT SQL_CALC_FOUND_ROWS wp_users.*
    FROM wp_users
    WHERE 1=1
    AND wp_users.ID IN (
    SELECT DISTINCT wp_posts.post_author
    FROM wp_posts
    WHERE wp_posts.post_status = ‘publish’
    AND wp_posts.post_type IN ( ‘post’, ‘page’, ‘attachment’, ‘product’ ) )
    ORDER BY user_login ASC

    • This topic was modified 6 years, 6 months ago by fariazz.
    • This topic was modified 6 years, 6 months ago by fariazz.
Viewing 1 replies (of 1 total)
  • Plugin Author WP Simple SEO

    (@wpsimpleseo)

    Hi,

    Thanks for the report on the slow query, which will be addressed in the next release.

    This would be run when building the author XML sitemap. There is no covert or underhand ‘gathering’ of data about your Users, but this query can certainly be optimized in our next update.

Viewing 1 replies (of 1 total)
  • The topic ‘Made my admin slow by querying users’ is closed to new replies.