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

 Couple of thoughts.

 1.  Would `medium|longblob` work better for the blob content on the
 `update_value` column?
 2.  I am wondering if a covering index for `KEY
 room_type_id(room,type,id)` would be tighter for polling since there might
 be queries that either include/exclude event types?

 Also, +1 to abstracting the `update_value` column name to somethign more
 general purpose, like `data`.

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