[wp-trac] [WordPress Trac] #10546: Change VARCHAR keys to SMALLINT

[WordPress Trac]

#10546: Change VARCHAR keys to SMALLINT
--------------------------------------+-------------------------------------
 Reporter:  mikeschinkel              |        Owner:         
     Type:  feature request           |       Status:  closed 
 Priority:  normal                    |    Milestone:         
Component:  Database                  |      Version:  2.9    
 Severity:  normal                    |   Resolution:  wontfix
 Keywords:  dev-feedback 2nd-opinion  |  
--------------------------------------+-------------------------------------
Changes (by westi):

  * status:  new => closed
  * resolution:  => wontfix
  * component:  General => Database
  * milestone:  Future Release =>


Comment:

 -1 to this and closing as WONTFIX.

 Moving to SMALLINT does not have a huge benefit and just makes things less
 obvious.

 It makes it much harder for plugins to create something for themselves as
 you now need a central registry for the type information and makes it all
 less obvious.

 I don't see that there is a performance issue with the way we doing things
 now - if there is an actual performance issue (not a theoretical one) then
 there would be a case for investigating something different but the
 current solution has worked fine for posts and comment types for a long
 time.

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