[wp-trac] [WordPress Trac] #14558: Separate Database Table Support for Custom Post Types

[WordPress Trac]

#14558: Separate Database Table Support for Custom Post Types
-------------------------------+------------------------------
 Reporter:  rahul286           |       Owner:  (none)
     Type:  feature request    |      Status:  reopened
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Posts, Post Types  |     Version:
 Severity:  normal             |  Resolution:
 Keywords:  2nd-opinion        |     Focuses:
-------------------------------+------------------------------

Comment (by CodeBard):

 After all these years, Im now 50/50 on this. The backwards compatibility
 concerns are major, and even if the custom post types are redirected to
 another table, that table would also choke when millions of rows were
 inserted to it anyway. So there may not be much gain from doing this since
 the performance concerns would need to be addressed eventually in either
 case.

 However, having the ''possibility'' of redirecting all db operations for
 any given post type to another table could work and it could address both
 the backwards compatibility concern and the performance concern with
 custom post type setups with millions of rows. Ie, if an arg is supplied
 in custom post definition for a different table, WP redirects all db
 operations for that post type to other tables than wp_post and wp_postmeta
 etc. This could be made happen in other ways of course, this is just an
 idea...

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