[wp-trac] Re: [WordPress Trac] #4778: Change enums to varchar

WordPress Trac wp-trac at lists.automattic.com
Mon Aug 20 14:56:54 GMT 2007


#4778: Change enums to varchar
----------------------------+-----------------------------------------------
 Reporter:  ryan            |        Owner:  anonymous  
     Type:  defect          |       Status:  new        
 Priority:  normal          |    Milestone:  2.3 (trunk)
Component:  Administration  |      Version:  2.3        
 Severity:  normal          |   Resolution:             
 Keywords:  schema enum db  |  
----------------------------+-----------------------------------------------
Comment (by Otto42):

 -1

 This is a really bad idea. The whole point of using an enum is to have a
 fixed set of values that are valid ones. They are stored as integers
 internally and make things somewhat speedier, since WordPress selects
 posts based on post_status more or less constantly. Changing it to a
 varchar would create a not-insignificant performance loss.

 If a plugin is making such a radical change as to require its own special
 post_status values, then it should be able to take the time to alter the
 table to allow that status.

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


More information about the wp-trac mailing list