| 1 | | This change is somewhat detrimental to sites with a large number of posts in the wp_posts table. The use of `get_available_post_mime_types` in media.php is particularly problematic, it results in a complete table scan and would benefit from some caching, |
| | 1 | This change is somewhat detrimental to sites with a large number of posts in the wp_posts table. The use of `get_available_post_mime_types` in media.php is particularly problematic, it results in a complete table scan and would benefit from some caching. |
| | 2 | |
| | 3 | In testing, we saw this query running on most wp-admin pages, especially post.php and edit.php, and adding at least a few seconds of page load time to any site with > 1 million rows in wp_posts. In some cases, it takes much much longer. |