[wp-trac] [WordPress Trac] #53217: Remove some columns from the wp_posts table (replace them with meta values)

WordPress Trac noreply at wordpress.org
Sun May 16 14:43:49 UTC 2021


#53217: Remove some columns from the wp_posts table (replace them with meta values)
--------------------------+-----------------------------
 Reporter:  alvarofranz   |      Owner:  (none)
     Type:  defect (bug)  |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  General       |    Version:
 Severity:  normal        |   Keywords:
  Focuses:                |
--------------------------+-----------------------------
 I suggest removing at least the following columns from the **wp_posts**
 table:


 {{{
 comment_status
 ping_status
 to_ping
 pinged
 comment_count
 }}}


 They only make sense for blog posts (and similar), but in the recent years
 I never used them. Almost all my posts are custom post types with
 different scopes.

 I never had a problem with combining a CPT + Custom Meta values to achieve
 an expected functionality.

 I think it's objectively true (not just an opinion) to affirm that this
 change would optimize the database.

 If I have 10 different CPTs that don't use those fields, why having all
 those "pseudo meta" fields hanging around. Why not just creating them as
 actual meta entries when necessary?

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/53217>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list