[buddypress-trac] [BuddyPress Trac] #6006: User Types API

[buddypress-trac]

#6006: User Types API
--------------------------+------------------
 Reporter:  boonebgorges  |       Owner:
     Type:  enhancement   |      Status:  new
 Priority:  normal        |   Milestone:  2.2
Component:  Core          |     Version:
 Severity:  normal        |  Resolution:
 Keywords:                |
--------------------------+------------------

Comment (by boonebgorges):

 Good points, johnjamesjacoby. Thinking about this a bit more,
 `BP_User_Query` doesn't actually reference the users table directly in
 most cases - it looks at the activity or xprofile table. See
 https://buddypress.trac.wordpress.org/browser/tags/2.1.1/src/bp-core/bp-
 core-classes.php#L241. I think - though please correct me if I'm wrong -
 that we can depend on those tables being in the same database as the root
 blog taxonomy tables, at least in any HyperDBish setup.

 The two cases where it matters are: 'popular' (queries usermeta) and
 'alphabetical' when hitting wp_users. I think in these cases, we might
 need to do a separate query that gets dumped into an `IN` clause. The
 negative performance implications of this strategy could be largely
 mitigated by aggressively caching usertype data, which I think we can
 probably do in much the same way that WP caches term trees (see eg
 `_get_term_hierarchy()`).

 When I build the first rev of this, I'll try to take these cases into
 effect, and hopefully you'll be willing to put some eyes on them :)

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/6006#comment:4>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac