[wp-trac] [WordPress Trac] #55463: Add a limit to _prime_*_cache functions

WordPress Trac noreply at wordpress.org
Fri Mar 25 12:18:11 UTC 2022


#55463: Add a limit to _prime_*_cache functions
--------------------------+----------------------------------------
 Reporter:  spacedmonkey  |      Owner:  (none)
     Type:  enhancement   |     Status:  new
 Priority:  normal        |  Milestone:  Awaiting Review
Component:  Cache API     |    Version:
 Severity:  normal        |   Keywords:  needs-patch good-first-bug
  Focuses:  performance   |
--------------------------+----------------------------------------
 The _prime_*_cache functions, like `_prime_post_cache` do a simple query
 to prime caches. This does a IN request to get all the objects. As we know
 the number of objects we wish returned, as have an array, we can add a
 simple LIMIT to the query to improve the performance of the query.

 Example:

 {{{#!php
 $fresh_posts = $wpdb->get_results( sprintf( "SELECT $wpdb->posts.* FROM
 $wpdb->posts WHERE ID IN (%s) LIMIT %d", implode( ',', $non_cached_ids ),
 count( $non_cached_ids ) ) );
 }}}

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/55463>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform


More information about the wp-trac mailing list