[wp-trac] [WordPress Trac] #23609: get_users() causes a huge number of SQL queries causing 500 server errors

WordPress Trac noreply at wordpress.org
Thu Feb 28 19:34:28 UTC 2013


#23609: get_users() causes a huge number of SQL queries causing 500 server errors
--------------------------+------------------
 Reporter:  dpacmittal    |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  3.6
Component:  Users         |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------

Comment (by nacin):

 Replying to [comment:6 dpacmittal]:
 > But isn't multiple queries the real problem here?

 Yes. all_with_meta caches usermeta all in one query.

 Of course, getting 15k users in one go is going to cause a problem for you
 no matter what — it's just a ton of data to return back to PHP. You are
 likely going to want to do limits and offsets.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/23609#comment:7>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list