[wp-trac] [WordPress Trac] #64696: Real time collboration effectively disables persistent post caches while anyone edits a post

[WordPress Trac]

#64696: Real time collboration effectively disables persistent post caches while
anyone edits a post
--------------------------------------+--------------------------
 Reporter:  peterwilsoncc             |       Owner:  (none)
     Type:  defect (bug)              |      Status:  new
 Priority:  normal                    |   Milestone:  7.0
Component:  Posts, Post Types         |     Version:  trunk
 Severity:  normal                    |  Resolution:
 Keywords:  has-patch has-unit-tests  |     Focuses:  performance
--------------------------------------+--------------------------

Comment (by davidbaumwald):

 Just thinking more about using post meta here, and IMHO it seems like the
 wrong path.  Happy to be corrected if any of the below is wrong.

 1.  Architecturally, the post meta table is a key–value metadata store,
 not a system for managing rapidly mutating application state.
 2.  Compaction further increases the churn.
 3.  Due to the nature of what's being stored, post meta cannot be
 adequately indexed to improve the throughput of a write-heavy system.
 4.  Customizations in plugins that hook into `add(?:ed)?_post_meta` hooks
 will be run for every RTC sync.

 For a long time now, "meta bloat" has been a concern in the ecosystem, and
 this would not improve the situation or perception.  Even my personal
 experience crosses paths daily with millions of `wp_postmeta` rows.

 WooCommerce moved to a denormalized, custom table storage for orders(HPOS)
 as a better fit.

 The custom table solves many problems, and seems to me to be the right
 tool for the job here:
  - Isolates RTC workload from core post/query APIs.
  - Enables proper indexing and benefits from auto-increment.
  - Allows safe compaction and predictable performance characteristics.
  - Abstracted to be useful for entities/screens other than posts.

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