[wp-trac] [WordPress Trac] #31245: Replace alloptions with a key cache

[WordPress Trac]

#31245: Replace alloptions with a key cache
-------------------------------------+-----------------------------
 Reporter:  rmccue                   |       Owner:  rmccue
     Type:  enhancement              |      Status:  assigned
 Priority:  normal                   |   Milestone:  Future Release
Component:  Options, Meta APIs       |     Version:  2.1
 Severity:  normal                   |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  performance
-------------------------------------+-----------------------------

Comment (by jerclarke):

 Replying to [comment:67 lkraav]:
 >
 > Heya @jeremyclarke are you able to show what you did to get better
 insight into what plugins are triggering option updates on every page
 load?

 In my case, I had an object caching plugin running, which meant that
 options were going straight there, and not to the DB, so I couldn't use
 normal DB profiling to figure it out.

 If you aren't using an object cache, I recommend Query Monitor:

 https://en-ca.wordpress.org/plugins/query-monitor/

 Easy to use and super effective at showing you what is taking time,
 causing queries, and eating up resources on your site. If you disable
 object cache, you should see anything updating options because it will
 cause DB queries that will show in the plugin.

 p.s. PLZ tag @jerclarke, unfortunately there's no way to rename my old
 wordpress.org account.

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