{"id":17466716,"date":"2024-03-01T16:10:42","date_gmt":"2024-03-01T16:10:42","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/yoast-performs-slow-sql-queries\/"},"modified":"2024-03-01T16:11:52","modified_gmt":"2024-03-01T16:11:52","slug":"yoast-performs-slow-sql-queries","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/yoast-performs-slow-sql-queries\/","title":{"rendered":"Yoast Performs Slow SQL Queries"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Hello, I&#8217;m investigating some performance issues and I see that Yoast tends to run some very long-running queries.  Here is an example:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT DISTINCT wp_users.ID\n\t\t\t\tFROM wp_users LEFT JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id )  LEFT JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id )  LEFT JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id )  LEFT JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id AND mt3.meta_key = 'wpseo_noindex_author' )  LEFT JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id )\n\t\t\t\tWHERE 1=1 AND wp_users.ID IN ( SELECT DISTINCT wp_20_posts.post_author FROM wp_20_posts WHERE wp_20_posts.post_status = 'publish' AND wp_20_posts.post_type IN ( 'post' ) ) AND (\n  (\n    (\n      wp_usermeta.meta_key = '_yoast_wpseo_profile_updated'\n      AND\n      (\n        ( mt1.meta_key = 'wp_20_user_level' AND mt1.meta_value != '0' )\n        AND\n        (\n          ( mt2.meta_key = 'wpseo_noindex_author' AND mt2.meta_value != 'on' )\n          OR\n          mt3.user_id IS NULL\n        )\n      )\n    )\n    AND\n    (\n      mt4.meta_key = 'wp_20_capabilities'\n    )\n  )\n)\n\t\t\t\tORDER BY wp_usermeta.meta_value+0 DESC\n\nFrom &#091;www.example_domain.com\/sitemap_index.xml] in &#091;\/nas\/content\/live\/example_env\/wp-content\/plugins\/wordpress-seo\/inc\/sitemaps\/class-author-sitemap-provider.php:12<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">What is this query doing and is there a way to opt out of it?  it seems to have something to do with author sitemaps.<\/p>\n","protected":false},"template":"","class_list":["post-17466716","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17466716","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17466716\/revisions"}],"predecessor-version":[{"id":17466718,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/17466716\/revisions\/17466718"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=17466716"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}