[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:  enhancement        |      Status:  closed
 Priority:  normal             |   Milestone:
Component:  Posts, Post Types  |     Version:
 Severity:  normal             |  Resolution:  wontfix
 Keywords:                     |     Focuses:
-------------------------------+----------------------

Comment (by pento):

 There's no performance benefit for views, every time you query the view,
 it effectively adds a join with the query that generates the view. MySQL
 doesn't have native support for materialised views.

 Writing CPT JSON files would suffer pretty terrible performance if there
 are regular writes (either posts created or update). It would effectively
 lock the entire CPT while the file is being written to disk.

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