@nappa on WordPress.org
Created ticket #27324 on Core Trac:increase performance of table joins on wp_users and wp_posts