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

 @JoeFusco My reading of Matt's comment above is that the addition of one
 table has been authorized for the current and future RTC features. It's a
 very rare occurrence so we're not going to be able to slide in two when
 it's possible to use one. The last time the table structure changed was to
 introduce term meta and links were deprecated to prep for the eventual
 removal of `wp_links`.

 No matter where awareness is stored, it's going to generate a lot of rows.
 If we use transients, they get added to the options table, if we use the
 RTC table, they get added there.

 I think it better to put awareness in the RTC table but maybe we can lean
 on the transients pattern and use a persistent cache if it's available.

 Re: Over queries, anything that allows us to limit the queries is an
 improvement over the current post meta implementation. My understanding is
 the query will be something along the lines of `SELECT * FROM table WHERE
 cursor > /* cursor position on last request, 0.25 seconds ago */ AND event
 = sync`. In most cases, that means that over query is one row and PHP is
 probably more efficient for filtering than adding a column and an index
 for said column.

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