Changeset 46178 for trunk/src/wp-includes/post.php

Timestamp:

09/19/2019 02:05:25 AM (5 years ago)

Author:

boonebgorges

Message:

Improve performance of trackback query in do_all_pings().

Previously, the direct SQL query used to identify trackbacks in
do_all_pings() performed poorly, due to an unindexed query against the
to_ping column. We improve performance in two ways. First, we switch
to using a postmeta flag for posts that require trackbacks to be sent;
queries joining against the postmeta table that check only the meta_key
are generally quite fast. Second, we switch to the use of WP_Query,
making the query cacheable and filterable using standard methods.

Props dshanske, spacedmonkey, janw.oostendorp, mrmadhat, birgire.
Fixes #36824.

File:

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

trunk/src/wp-includes/post.php

@@ -6787 +6787 @@
     add_post_meta( $post_id, '_encloseme', '1' );
 
+    $to_ping = get_to_ping( $post_id );
+    if ( ! empty( $to_ping ) ) {
+        add_post_meta( $post_id, '_trackbackme', '1' );
+    }
+
     if ( ! wp_next_scheduled( 'do_pings' ) ) {
         wp_schedule_single_event( time(), 'do_pings' );