Changeset 19918 for trunk/wp-includes/post.php

Timestamp:

02/14/2012 03:09:35 PM (13 years ago)

Author:

ryan

Message:

Split the main WP_Query posts query into two queries to avoid temp tables. Leverage cache to avoid second query in persistent cache environments. Props scribu, cheald, prettyboymp. see #18536

File:

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

trunk/wp-includes/post.php

@@ -5319 +5319 @@
     }
 }
+
+/**
+ * Adds any posts from the given ids to the cache that do not already exist in cache
+ *
+ * @since 3.4.0
+ *
+ * @access private
+ *
+ * @param array $post_ids ID list
+ * @param bool $update_term_cache Whether to update the term cache. Default is true.
+ * @param bool $update_meta_cache Whether to update the meta cache. Default is true.
+ */
+function _prime_post_caches( $ids, $update_term_cache = true, $update_meta_cache = true ) {
+    global $wpdb;
+
+    $non_cached_ids = _get_non_cached_ids( $ids, 'posts' );
+    if ( !empty( $non_cached_ids ) ) {
+        $fresh_posts = $wpdb->get_results( sprintf( "SELECT $wpdb->posts.* FROM $wpdb->posts WHERE ID IN (%s)", join( ",", $non_cached_ids ) ) );
+
+        update_post_caches( $fresh_posts, 'any', $update_term_cache, $update_meta_cache );
+    }
+}
+