[wp-trac] [WordPress Trac] #35096: Every option call results in a database query on multisite

[WordPress Trac]

#35096: Every option call results in a database query on multisite
--------------------------------+------------------------------
 Reporter:  buley               |       Owner:
     Type:  defect (bug)        |      Status:  reopened
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:  4.4
 Severity:  normal              |  Resolution:
 Keywords:                      |     Focuses:  multisite
--------------------------------+------------------------------

Comment (by buley):

 That's the case, thanks for the clarity. In the case of object-cache
 dropin failure, which seems easy and I know to be common, it would seem
 prudent for core not to get this alloptions amnesia. It's seems wasteful
 and unnecessary to run 250 of the same query when no options have changed
 in the milliseconds between them. It's a failure case, and the onus is on
 the object-cache.php drop in not to fail, but WordPress fails
 spectacularly when it happens and I believe this is unnecessary.

 I should have remembered my lesson when we lost weeks to this at Forbes
 (the consultants came out very rich but didn't find the cause either) but
 I just ran into it again and lost another week. I'm no amateur - and there
 turned out to be nothing wrong with my code - just that a bunch of
 WooCommerce plugins started autoloading and finally pushed me beyond the
 1mb limit. It's horrible, horrible problem to debug when it happens.

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