[wp-trac] [WordPress Trac] #28160: Get authors user query in-efficient when dealing with large numbers of users.

[WordPress Trac]

#28160: Get authors user query in-efficient when dealing with large numbers of
users.
-------------------------+------------------------------
 Reporter:  l3rady       |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Users        |     Version:  3.9
 Severity:  major        |  Resolution:
 Keywords:               |     Focuses:
-------------------------+------------------------------

Comment (by OllieJones):

 Rick James and I have released a plugin to change the indexes on
 wp_usermeta (and on other tables) to give a significant performance boost
 to the kind of query in this ticket.

 Here's the plugin. https://wordpress.org/plugins/index-wp-mysql-for-speed/
 Nothing would make us happier than for our plugin to be rendered obsolete
 by improvements in core or elsewhere.

 Here's something I wrote for a related ticket.
 https://core.trac.wordpress.org/ticket/33885#comment:86

 @SergeyBiryukov says they are looking at this indexing opportunity in the
 performance team. https://github.com/WordPress/performance/issues/132

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/28160#comment:14>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform