[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 23:57:01 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:  Posts, Post Types  |     Version:
 Severity:  normal             |  Resolution:
 Keywords:                     |     Focuses:
-------------------------------+------------------------------

Comment (by SergeyBiryukov):

 Hi there, welcome to WordPress Trac! Thanks for the ticket.

 Just noting that backward compatibility would be a concern here. While
 these fields might not be used often, or at all, on some installs,
 removing them would unnecessarily break the installs that do use them, so
 we would need to find a way to avoid that to move the ticket forward.

 Moving them to meta entries might also result in more complex database
 queries, so some performance tests before and after would be helpful to
 show if there is any improvement and whether the change is worth it.

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


More information about the wp-trac mailing list