[wp-trac] [WordPress Trac] #40613: Add query cache to WP_User_Query class

WordPress Trac noreply at wordpress.org
Wed Apr 25 20:37:56 UTC 2018


#40613: Add query cache to WP_User_Query class
-------------------------------------+------------------------------
 Reporter:  johnjamesjacoby          |       Owner:  (none)
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Awaiting Review
Component:  Users                    |     Version:  3.1
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  performance
-------------------------------------+------------------------------

Comment (by strategio):

 We are running a big site with more than 100k users and this is causing an
 important performance hit for us. I think an in-memory caching would
 already help. For instance, a user drop-down is displayed twice in "Posts
 -> All Posts" and for each call, `get_users` is called with the same
 arguments. One unique query takes ~3s, so this is an important place of
 improvement for us.

 If you still prefer not to add caching in `get_users`, let me know and I
 will open a ticket to fix it at least in
 `WP_Posts_List_Table::inline_edit` where `wp_dropdown_users` is called
 twice.

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


More information about the wp-trac mailing list