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

 @JoeFusco

 1. Don't we need indexes on `type` and `client_id` given the proposed
 awareness update query in comment:63?
 2. I don't have a specific use case in mind, but an index on `user_id`
 might be wise in order to allow queries like "show me all the rooms where
 user 123 is collaborating."
 3. Nitpick, but `update_value` might be better named as `data` or
 `collaboration_data` given potential future use cases.

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