Changeset 48225

Timestamp:

06/30/2020 11:03:57 AM (4 years ago)

Author:

SergeyBiryukov

Message:

Comments: Introduce wp_update_comment_type_batch_size filter for the comment batch size in _wp_batch_update_comment_type().

Follow-up to [47597].

Props dchymko.
Fixes #50513. See #49236.

File:

• trunk/src/wp-includes/comment.php (modified) (1 diff)

trunk/src/wp-includes/comment.php

@@ -3832 +3832 @@
     wp_schedule_single_event( time() + ( 2 * MINUTE_IN_SECONDS ), 'wp_update_comment_type_batch' );
 
-    // Update the `comment_type` field value to be `comment` for the next 100 rows of comments.
+    /**
+     * Filters the comment batch size for updating the comment type.
+     *
+     * @since 5.5.0
+     *
+     * @param int $comment_batch_size The comment batch size. Default 100.
+     */
+    $comment_batch_size = (int) apply_filters( 'wp_update_comment_type_batch_size', 100 );
+
+    // Update the `comment_type` field value to be `comment` for the next batch of comments.
     $wpdb->query(
-        "UPDATE {$wpdb->comments}
-        SET comment_type = 'comment'
-        WHERE comment_type = ''
-        ORDER BY comment_ID DESC
-        LIMIT 100"
+        $wpdb->prepare(
+            "UPDATE {$wpdb->comments}
+            SET comment_type = 'comment'
+            WHERE comment_type = ''
+            ORDER BY comment_ID DESC
+            LIMIT %d"
+        ),
+        $comment_batch_size
     );