[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 peterwilsoncc):

 As Matt has authorized a new table for RTC to resolve the performance
 impacts, we (contributors working on this ticket) can move on to an
 architectural discussion.

 Primarily, we need to figure out the table and index structure:

 * `WP_HTTP_Polling_Sync_Server` has been written for a future in which
 additional object types have real time collaboration
 * Core objects are posts, comments, terms and users. Posts include post
 types as sub objects
 * Plugins frequently add their own object, eg WooCommerce has orders;
 email plugins have email campaigns, etc
 * What data types are needed for various aspects of the table
 * What data currently stored in the `meta_value` blob of data ought to be
 stored in it's own column


 Miscellaneous questions for consideration:

 * Should awareness be managed via the table or just syncing?
 * Related to the above, on the product call (I couldn't attend), I
 understand presence indicators were discussed for other pages, eg list
 tables. Is this something that can be stored here too?
 * MS requires manual intervention to upgrade tables, how best to manage
 RTC prior to these being added
 * What is the permissions model: is it based on the object being
 collaborated on, new meta caps, some combination of the two?

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