[wp-trac] [WordPress Trac] #17382: XMLRPC wp_getUsersBlogs Scalability

[WordPress Trac]

#17382: XMLRPC wp_getUsersBlogs Scalability
--------------------------+-----------------------------
 Reporter:  bmorneau      |      Owner:
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  XML-RPC       |    Version:  3.0.1
 Severity:  normal        |   Keywords:  needs-patch
--------------------------+-----------------------------
 If there is a root blog with many sub blogs on it and a user that is an
 admin on each sub blog, then when the when the XML RPC method
 wp_getUsersBlogs() is called it does not scale very well. My PHP
 memory_limit setting was 128MB, and the XML RPC request died when a user
 was a member of 230+ blogs. I noticed that the number of queries made to
 the database for a single user that has many blogs that they are an admin
 is very high.

 Affected line:
 http://core.trac.wordpress.org/browser/tags/3.0.1/xmlrpc.php#L443

 I don't know exactly how the code would have to change so I am not
 providing a patch.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/17382>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software