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

WordPress Trac wp-trac at lists.automattic.com
Wed Aug 5 18:29:37 UTC 2009


#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  |  
--------------------------------------+-------------------------------------

Comment(by Denis-de-Bernardy):

 Replying to [comment:2 westi]:
 > Moving to SMALLINT does not have a huge benefit and just makes things
 less obvious.

 Actually, it potentially makes things faster with large amounts of data,
 due to the much smaller index. But leaving this closed, as it goes against
 the general philosophy of WP.

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


More information about the wp-trac mailing list