How to obtain the recent posts without their content in an efficient way?

Question

How to obtain the recent posts without their content in an efficient way?

silviubogan

2021年9月17日 17:58

It would be great to make a single DB request but I don't know how to do that either. I have this code and it works but I want to change it to be more efficient:

$cs = get_categories(array(
    'orderby' = 'name',
    'order' = ASC,
));

$params = array(
    'last_five_articles' = array()
);
foreach ($cs as $c) {
    $rp = wp_get_recent_posts(array(
        'numberposts' = 5,
        'post_status' = 'publish',
        'category' = $c-term_id
    ));

    foreach ($rp as $idx = $crt)
    {
        $rp[$idx][post_content] = NULL;

        $rp[$idx][url] = esc_url(get_permalink($crt[ID]));

        $rp[$idx][is_current] = $crt[ID] === get_the_ID();
    }

    $params['last_five_articles'][$c-slug] = $rp;
}

Update 1

The fields that I use from each post are:

url (custom field)
is_current (custom field)
post_title
post_date

The rest should be ignored.

Topic recent-posts functions categories query-posts Wordpress

Category Web

Tom J Nowell · Accepted Answer · 2021年9月17日 16:21

How to obtain the recent posts without their content?

The same way you would any other post, just don't use the post content.

Not fetching the post content will not improve performance, and may actually hurt performance. This is because WordPress would need to make an additional query if it needed the post content. When you query a post, WP primes temporary caches, this way it only requests a post once in a request, no matter how many times you ask for it.

By being more specific about which fields you want, you may think you're improving performance, but you're actually hurting it as WP can no longer cache, and has to generate bespoke couture results.

Asking only for specific fields is great for minimising bandwidth use between a server and a browser, you get a nice chunk of data with a footprint perfect for a mobile phone. But you are not a mobile phone, you're a server in a data centre, and the database is probably on the same machine.

You want to be able to cache and bulk request data so that the query is cheap and reusable. This is especially powerful when combined with object caching.

It would be great to make a single DB request but I don't know how to do that either.

This cannot be done, what you want to do requires multiple queries.

Even if you did find an API function to do it, that function would make 5 separate queries internally, no performance gains would be made.

other notes:

wp_get_recent_posts is a helper function. Cut it out and go directly to WP_Query
Posts are not arrays, they are meant to be objects of type WP_Post, so use $post->post_content instead
You would be better off storing either the post IDs or the post itself in $params['last_five_articles']
You should not modify post objects directly, it is bad practice and will cause issues and inconsistencies that lead to bugs.
- For example, if you want to modify post titles, don't change the posts title field, use a filter to modify the output instead

How to obtain the recent posts without their content in an efficient way?

Update 1

About