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

 @ellatrix some potential problems with using post meta:

 * Large sites can have millions of post meta entries, that would impact
 every read and write and RTC may write multiple times every second. We'd
 need to benchmark this to check if that's a problem in practice in a live
 site.
 * Plugins may hook into `update_post_meta` and similar, and run
 computations that would slow down RTC.
 * For MyISAM tables, each update would
 [https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html lock the
 entire post_meta table]. For InnoDB, I think we're fine locking-wise.

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