[wp-trac] Re: [WordPress Trac] #10209: user - additional fields / removing unnecessary fields

[WordPress Trac]

#10209: user - additional fields / removing unnecessary fields
---------------------------------------------------------------+------------
 Reporter:  F J Kaiser                                         |        Owner:         
     Type:  feature request                                    |       Status:  closed 
 Priority:  normal                                             |    Milestone:         
Component:  Users                                              |      Version:  2.7.1  
 Severity:  normal                                             |   Resolution:  invalid
 Keywords:  user, additional, field, extra, data, unnecessary  |  
---------------------------------------------------------------+------------

Comment(by Denis-de-Bernardy):

 I'm aware, but the general trend with core devs has been the following for
 as long as I can remember: "We put all of the custom stuff into the meta
 table, and leave the db tables untouched."

 As you highlight in your example, one can end up needing three joins on a
 potentially huge meta table without any useful index to the rescue. If you
 really need queries like that, btw, seriously consider adding extra tables
 and/or columns using the dbDelta. It'll go *much* faster than anything
 user_meta will return.

 On a separate note, don't miss the new the_author_meta() template
 function.

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