Changeset 55749 for trunk/src/wp-includes/class-wp-comment-query.php

Timestamp:

05/11/2023 12:25:51 PM (21 months ago)

Author:

spacedmonkey

Message:

Comments: Always lazily load comment meta.

In [34270] introduced lazy loading of comment meta. However, this was only in the context of WP_Query. Other parts of the codebase, like WP_Comment_Query did not lazily load comment meta. In this change, calls to update_meta_cache are now replaced with wp_lazyload_comment_meta, that instead of priming comment meta caches, just adds them to the queue to be primed it ever called. This results in far less database queries, as there a number of places where comment meta is being primed unnecessarily and never used. Adding everything to the comment meta queue, also means that if comment meta is used, that is all loaded in a single database / cache call.

Follow on from [55671], [55747].

Props spacedmonkey, peterwilsoncc, flixos90, mukesh27.
Fixes #57801.

File:

• trunk/src/wp-includes/class-wp-comment-query.php (modified) (2 diffs)

trunk/src/wp-includes/class-wp-comment-query.php

@@ -482 +482 @@
         $comment_ids = array_map( 'intval', $comment_ids );
 
+        if ( $this->query_vars['update_comment_meta_cache'] ) {
+            wp_lazyload_comment_meta( $comment_ids );
+        }
+
         if ( 'ids' === $this->query_vars['fields'] ) {
             $this->comments = $comment_ids;
@@ -487 +491 @@
         }
 
-        _prime_comment_caches( $comment_ids, $this->query_vars['update_comment_meta_cache'] );
+        _prime_comment_caches( $comment_ids, false );
 
         // Fetch full comment objects from the primed cache.