XMLRPC wp_getUsersBlogs Scalability
|Reported by:||bmorneau||Owned by:|
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.
I don't know exactly how the code would have to change so I am not providing a patch.