[wp-trac] [WordPress Trac] #36799: Extra field in wp_posts table

[WordPress Trac]

#36799: Extra field in wp_posts table
-------------------------------+----------------------
 Reporter:  selnomeria         |       Owner:
     Type:  feature request    |      Status:  closed
 Priority:  normal             |   Milestone:
Component:  Posts, Post Types  |     Version:
 Severity:  normal             |  Resolution:  wontfix
 Keywords:                     |     Focuses:
-------------------------------+----------------------
Changes (by swissspidy):

 * status:  new => closed
 * resolution:   => wontfix
 * milestone:  Awaiting Review =>


Comment:

 I don't really see a benefit of adding a new column to `wp_posts` that
 badly replicates the postmeta table.

 You can't really index such a column in a good way in the database and you
 also can't order by values in it. Additionally, post meta queries are
 cached, so performance is not a big concern there. Short, it's not useful.

 > currently, i myself, use post_content_filtered for this job...

 I suggest you to add such a column yourself in your plugin if you really
 need it. If it's just for performance, you should look into implementing
 an object cache like Memcached or Redis.

 It's not something we'd add in core at this point though.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/36799#comment:2>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform