[wp-meta] [Making WordPress.org] #1829: O2: Reduce number of uncached queries

Mon Jul 11 15:29:45 UTC 2016

#1829: O2: Reduce number of uncached queries
--------------------------------------+-----------------
 Reporter:  ocean90                   |      Owner:
     Type:  defect                    |     Status:  new
 Priority:  normal                    |  Milestone:
Component:  Make (Get Involved) / P2  |   Keywords:
--------------------------------------+-----------------
 It seems like O2 isn't as fast as P2. One reason might be the number of
 queries:

 ----

 Page: https://make.wordpress.org/meta/2016/06/08/plugin-directory-v3-chat-
 summary-61/

 With O2: Time : 4.172 | DB Queries: 104 | Memory: 11,4/256M | Cache Hits:
 9021 | Cache Misses: 1
 With P2: Time : 1.334 | DB Queries: 14 | Memory: 14,5/256M | Cache Hits:
 3841 | Cache Misses: 0

 ----

 Page: https://make.wordpress.org/meta/2016/07/11/devhub-weekly-chats-are-
 restarting/

 With O2: Time : 2.430 | DB Queries: 72 | Memory: 9,6/256M | Cache Hits:
 3960 | Cache Misses: 1
 With P2: Time : 0.960 | DB Queries: 13 | Memory: 13,5/256M | Cache Hits:
 2712 | Cache Misses: 0

 ----

 Most of them are generated by `wp_get_object_terms()` and it looks like
 it's the same query executed multiple times.

--
Ticket URL: <https://meta.trac.wordpress.org/ticket/1829>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org