Soliciting feedback on user query optimization

I’ve just put up a first-draft patch for the new BP_User_Query object, which overhauls (and highly optimizes) the way that BuddyPress performs user queries: #4060. Please read the patch and my comments if you fall into one of the following categories:

  • You’ve developed for a BP installation with a very large userbase and can provide data points
  • You’re a MySQL wonk and can analyze the optimizations provided by BP_User_Query
  • You have developed plugins or other customizations that have used the ‘bp_core_get_paged_users_sql’ or ‘bp_core_get_total_users_sql’ filters, and are concerned about the backward compatibility plan for BP_Core_User::get_users() and these two filters.