[wp-trac] [WordPress Trac] #33306: Only Query for author ID if user is member of blog

[WordPress Trac]

#33306: Only Query for author ID if user is member of blog
------------------------------------+-----------------------------
 Reporter:  sboisvert               |      Owner:
     Type:  enhancement             |     Status:  new
 Priority:  normal                  |  Milestone:  Awaiting Review
Component:  General                 |    Version:  trunk
 Severity:  normal                  |   Keywords:
  Focuses:  multisite, performance  |
------------------------------------+-----------------------------
 In WP_Query if a user is part of the multisite install but is not part of
 the current blog the query is still altered from only finding public posts
 to finding public posts and those that are private and from that
 author_id. While this never has an impact on the returned end results, not
 having private and author ID as a parameter lets MySQL optimize the
 queries and in the circumstances this has been tested on (large site, lots
 of posts lots of users) makes them run faster. On a site without multisite
 installed this will have the same behavior.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/33306>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform