[wp-trac] [WordPress Trac] #4013: post_ID in schema not consistent across tables

[WordPress Trac]

#4013: post_ID in schema not consistent across tables
---------------------------+------------------------------------------------
 Reporter:  charleshooper  |       Owner:  charleshooper            
     Type:  defect         |      Status:  new                      
 Priority:  normal         |   Milestone:  2.3                      
Component:  Optimization   |     Version:  2.2                      
 Severity:  normal         |    Keywords:  has-patch database schema
---------------------------+------------------------------------------------
 Since r5078 the largest possible value for {{{wp_posts.ID}}} due to the
 cast to int is limited to 2,147,483,647 on most 32-bit platforms. The
 column for {{{wp_comments.comment_post_ID}}} is also an INT-sized value,
 as opposed to the BIGINT-sized value in {{{wp_posts}}}. I am recommending
 we reduce the size of the post_IDs in the schema from BIGINT to INT. Doing
 so will greatly reduce the table and index size for the tables
 {{{wp_comments}}}, {{{wp_post2cat}}}, {{{wp_postmeta}}} and is just good
 practice in regards to efficient database design.

 See also #3725.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/4013>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software