[wp-trac] [WordPress Trac] #10201: Switch roles to use single role, and no user-specific caps

[WordPress Trac]

#10201: Switch roles to use single role, and no user-specific caps
-------------------------------+--------------------------------------------
 Reporter:  Denis-de-Bernardy  |       Owner:             
     Type:  task (blessed)     |      Status:  assigned   
 Priority:  normal             |   Milestone:  2.9        
Component:  Role/Capability    |     Version:  2.8        
 Severity:  normal             |    Keywords:  2nd-opinion
-------------------------------+--------------------------------------------

Comment(by sambauers):

 We experience poor performance on large usermeta tables in bbPress due to
 the way roles are stored. However, I overcame most of the issues with a
 plugin (and a single table). Might be a good reference.

 http://bbpress.org/plugins/topic/user-roles-table-for-bbpress/

 "The other option is a whole new set of tables.. which.. those who are
 sane (And there are some insane people in WP Dev..) realise that its not
 really needed."

 Storing the role as a "varchar" in the usermeta table will require an
 additional column in the wp_usermeta table as current meta_value column is
 "longtext". If that change doesn't happen then the roles will still be
 non-indexed and there will be little or no speed improvement over doing a
 "LIKE" query on the existing serialised arrays. We might prefer a single
 additional table in the end instead (speed, storage and sanity wise it's a
 better option).

 Also, the capabilities in bbPress are hardcoded (not stored in the DB at
 all), but pluggable. Which hasn't hindered usage of them in the slightest.

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