[wp-trac] [WordPress Trac] #50430: wp_dropdown_users() memory exhausted for large user tables

[WordPress Trac]

#50430: wp_dropdown_users() memory exhausted for large user tables
--------------------------+-----------------------------
 Reporter:  trek7k        |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 wp_dropdown_users() is used in many places throughout the admin, like /wp-
 admin/users.php where it's called for reassigning a deleted user's posts.

 This function quickly exhausts memory (not to mention, browsers have
 trouble rendering such a large menu, and usability is impossible) for big
 user tables (400,000+ users, tested).


 {{{
 PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried
 to allocate 19398624 bytes) in /var/app/current/wp-includes/user.php on
 line 1202
 }}}


 Instead of using an html select menu, a typeahead text box that queries
 the user database could be much more efficient and would solve the
 problem.

 I'm classifying this as a bug and not an enhancement because for large
 sites, it is currently impossible to delete users as the script will often
 run out of memory at "Attribute all content to:".

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