Since wordpress multisite uses different tables for all blogs, it is very inefficient to get all recent articles of all blogs (content aggregation) on display time since you have to query all blogs, sort the articles by date and display the ammount you need.
Plugins like WordPress Post Indexer (https://premium.wpmudev.org/project/post-indexer) additional write all posts into one central db table in the moment you insert or update them. From there, you can query them very efficiently.
I used the mentioned plugin by myself – its worth to try.
I’m not associated with the creator.
There are some things to consider too: For example: if you want display custom post meta fields, you’ll have to use switch_to_blog.
Related Posts:
- Get posts from Network (Multisite)
- switch_to_blog() performance considerations & alternatives
- Merging multiple wp_query objects
- How to get post from all Blog Multisite to the Main Site?
- Multisite wp_query & switch_to_blog issue
- the_post() within switch_to_blog() altering my excerpt
- When should you use WP_Query vs query_posts() vs get_posts()?
- When to use WP_query(), query_posts() and pre_get_posts
- WP_Query orderby date not working
- How to use the_posts_navigation for wp_query and get_posts?
- WP_Query vs get_posts
- meta_query: using BETWEEN with floats and/or casting to DECIMAL
- How to order by post_status?
- Using get_posts vs. WP_Query
- Delete all posts from WordPress except latest X posts
- Sanitation needed for WP_Query or get_posts calls?
- Differences Between WP_Query() and get_posts() for Querying Posts?
- get_posts with multiple categories
- get_template_part in for loop
- Use of caller_ get_ posts
- How-to exclude terms from the main query the most performant way?
- Is it possible to select against a post’s parent’s fields with WP_Query?
- WordPress Custom Query to show posts from last x years
- Query all posts where meta value is empty
- Get posts by meta data OR title
- Get_post() with meta_key when compare is a date
- get_posts not finding argument: post_name
- Meta Query with date and time on the same Day before given time
- latest 5 posts using switch_to_blog loop
- Get posts with condition on comment meta value
- Function to check if author has posted within the last x days
- Use post__in and post__not_in together?
- WP_Query on different site in a multisite setup
- What should I use, get_posts or wp_query for less CPU load?
- Different Results with query(‘s=computer’) vs get_posts(‘s=computer’)?
- WP Query post meta value
- How can I hide posts that are over 2 years old
- Get all posts without tags
- get_posts() seemingly ignoring post_type
- Can not switch the queried post in pre_get_posts hook
- Get posts from the Main site to sub site – WordPress MultiSites Network
- How to find out what “Blog pages show at most” is set to [duplicate]
- Count posts returned by get_posts in external PHP script
- How can i get the last post from wp multisite?
- Trying to check and see if a post has a featured image outside of the main loop
- WP_query category__in not working, only pulls from first category
- Date query not inclusive despite parameter being true
- Use meta_query to display events by date in custom field
- SELECT * FROM $wpdb->posts WHERE ID > 160
- Ordering by meta_value AND date NOT WORKING with wp_query
- How to show recent and upcoming birthdays using meta_query
- Adding multiple post queries with parent and children to page – Best Way
- How do you Query posts with nothing in common?
- WP_Query, tax_query and term_meta: How to?
- Meta Query for specific months
- Get posts for last working week in WP_Query
- WP_Query meta_query >= date
- get_posts – get all posts by array of author
- Create a sitemap without a plugin – get parent pages only?
- Complex date range with WP_Query and BETWEEN
- Creating a custom search for a specific post type
- get_posts – find out if querystring was crap and fallback is used
- Comparing dates in custom field
- Get posts for which a custom field is not present, with get_posts
- Creating query to show which editor (classic or block) was last used to edit a post/page
- get_posts() not working with multiple statuses
- How to display upcoming events by dat with Modern Events Calendar Lite
- Orderby ASC changes to DESC in WP_Query
- Return only post(s) which have post_excerpt
- Database Queries Optimization with new WP_Query
- Return Taxonomy/Term Information with Posts (WP_Query/get_posts)
- Complex WP_Query order request: DESC by day, but then ASC by time
- Help with WP_Query – Too many mySQL queries
- WP_Query() and get_posts() can’t handle over a thousand posts?
- WordPress multisite – fallback on subsites to main site on 404 and dealing with switch_to_blog function
- add active class based on permalink and url
- WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
- Weird orderby => post__in issue
- Need Help For WPQuery
- Multisite – Global CPT – advices?
- Why does get_posts only show results for Admins or logged-out users?
- Conflict with get_posts and the_content
- WP_Query post_parent parameter always returns children of current page
- Taxonomy and Date in same query?
- get_post_meta slowing down my page load (in a plugin)
- Shortcode for latest -not expired- posts
- date_query seems to be ignored by wp_query
- WP Group posts by year(desc) > month(desc) > date(asc)
- How to show more post at a given category?
- Get posts by list of post IDs ordered by those IDs?
- How to count posts with specific arguments
- Check return value of get_posts
- Reset WordPress Post Query to default
- Display Current Post’s Position in Custom Taxonomy
- Best choice for multiple loop in page?
- Get all posts which was posted on X Days WordPress
- Query post with meta value in set of values
- meta_query: check if number exists
- get_posts output always same post
- WordPress Custom Search Form Displaying Unexpected Results