Changeset 6544 for trunk/src/includes/admin/tools/repair.php

Timestamp:

06/14/2017 06:45:49 PM (9 years ago)

Author:

johnjamesjacoby

Message:

Performance: Last pass at 2.6 performance tuning.

• Keep a local cache of non-options that aren't in the database, to avoid multiple database misses for options we know aren't in the database after wp_load_alloptions() is called
• Stop getting all favorite IDs and subscription IDs when checking if a user has favorited or subscribed to something, because these queries are expensive joins that are difficult to cache & invalidate
• Consolidate forum/topic favorites & subscriptions logic back into central routers, to make it easier to handle taxonomy term subscriptions in the future, and remove nested filter calls that make the call-stack confusing
• Informally deprecate some forum & topic specific fav/sub functions
• Rename one of the engagements remove functions to better match existing naming pattern
• Typo fixes & general code quality improvements
• Bump slow tests threshold up to 500 for now, and we can bring back down later (my 12" MacBook runs this pretty slowly, so I'd like to play with this more)
• Unit tests are all passing, and more quickly, maybe surprisingly

This should result in around 20 fewer database hits on non-persistent-cache sites, on average. When viewing single topics & replies, this will result in more than 25 fewer database hits.

File:

• trunk/src/includes/admin/tools/repair.php (modified) (2 diffs)

trunk/src/includes/admin/tools/repair.php

@@ -626 +626 @@
 
 /**
- * Clean the users' topic subscriptions
+ * Clean the user topic subscriptions
  *
  * @since 2.0.0 bbPress (r2668)
@@ -695 +695 @@
 
 /**
- * Clean the users' forum subscriptions
+ * Clean the user forum subscriptions
  *
  * @since 2.5.0 bbPress (r5155)