Excellent responses on WP Hackers:
http://lists.automattic.com/pipermail/wp-hackers/2012-June/043213.html
What you’re doing with that query, is loading EVERY matching post into
memory, including the full post contents.
As you can imagine, this is probably quite a lot of items.You can pass ‘fields’ => ‘ids’ into WP_Query to simply return a list
of matching post_ids instead, which should reduce the memory (and
processing time) significantly:http://codex.wordpress.org/Class_Reference/WP_Query#Post_Field_Parameters
Related Posts:
- Fatal error: Class ‘ms\WP_Query’ not found on plugin initialization [closed]
- Register custom query args parameter for WP_Query()
- How to add multiple custom URL variables?
- Getting wrong relationship value in $args in wp_Query?
- Check for featured image in WP_Query
- Why Does get_posts() Return an Empty Set?
- How to get data from WordPress $wpdb into React Gutenberg Blocks Frontend?
- get_posts / WP_Query Memory size of 134217728 bytes exhausted
- How to ensure “the_content” filter runs only for the main displayed content?
- add_filter and remove_filter added before and after wp_query
- How to get all images and their thumbnails from wp media library
- How to create a dynamic page based on form data with a plugin?
- How to Display Custom Post Type’s Gallery (images ) in Through WP_Query
- Handling form request from plugin file
- How can I free up the memory used by update_post_meta?
- Cannot search post by taxonomy
- How to get orders with used coupon in WooCommerce
- WP_Query with tax_query, order by most ‘matches’
- How to print raw query from WP_Query class just like in CodeIgniter
- WP_Query returns no results
- Finding posts containing matching array elements in a meta field usign WP_Query
- Create a custom display order in the main menu
- manage_posts_custom_column, showing serial number using increment in loop
- Error : “Cannot use object of type WP_Post as array in”
- Proper way to run wp_query from inside a plugin
- using new WP_Query in save_post function alters $post
- I’m designing a plugin to create database indexes. Suggestions?
- Slow WP_query due to nested wp_query. Need Suggestions
- ORDER BY wp_post custom column name in wp_query
- How to create database table, add data, update and delete using wpdb via plugins?
- Elementor custom Query with ACF fields to show matching woocommerce products custom fields
- WP_Query filters
- How to fetch only current hour posts?
- How to get Metabox custom field to show checked if value is updated using post meta query?
- WordPress pre_get_posts with combined results of two queries (OR)
- Search: how to extend the existing search to include a custom table
- how to get all the child category name in a specified category name?
- Optimising a big WordPress site
- how to invoke wordpress API from other existing PHP system
- How I can use order by of the custom post title?
- How to query children by post name/slug
- 400 Bad Request, in wordpress theme development, wp_ajax
- Prevent WordPress automatically processing certain URL queries
- Store custom meta box data as serialized array
- how to load the comment template from a plugin
- How remove trashed WooCommerce orders from wc_get_orders() result?
- Auto-complete or auto-suggest from stored data in database
- Get post thumbnail in WP_Query
- Pagination not working with custom wp_query
- Get Posts by IDs (optionally)
- Adjust query on single
- How to add some basic inline CSS using existing plugin or theme?
- WP_Query order posts by category
- Is it possible to use the MySQL’s ORDER BY FIELD() clause as part of the pre_get_posts hook?
- Multiple dynamic Tax Query – pass taxonomy argument from array
- WP_Query not ordering correctly
- How to check category name available or not
- Home page is not loading, where in other pages are displaying on the site
- how to create a shortcode from a variable in plugin
- User meta query using Wildcard
- Group By in a Metaquery
- WP Query date_query with several date range
- Making Woocommerce optimized for more than 500k products
- Post Pagination does not working on WP-Query
- WP Query Relations / Compare
- pull data from wordpress database
- How can I query 3 posts from diferente categories (one of each category)
- Query only title/field/featured media of posts [closed]
- Custom MySQL query to pull out Advanced Custom Fields?
- post_results filter confused by pagination in sidebar and main section
- Can’t get query string in ajax call
- Get custom wp_query search results to appear on search.php
- loop and in admin header problem
- How do I query posts and have their related taxonomies returned in the results?
- Best Way to Inventory the Media Library of a 200+ Multisite Installation?
- $_GET vs get_query_var()
- What is the meta_query key name for the woo product average rating? [closed]
- get the queried_object of an url
- Return custom product in ajax call loop
- filter on get_posts efficiently
- Is get_option function cached?
- How to Rewrite WordPress URL for a Plugin
- Determine which theme location a wp_get_nav_menu_items is for
- How to use wp_set_password in a plugin?
- URL rewriting must be activated manually for my plugin
- PHP logging framework to be used with WordPress
- How to Load Plugin JS in theme’s footer section
- Add notification bubble notice in navigation using transients
- Custom plugin – $post_id in wp_head
- is it recommended to use WP_List_Table?
- Uploaded attachment not set as featured image
- Use options to control jQuery plugin
- Using custom IDP with WP
- Trying to run a Ajax request from a checkout form in woocommerce via a custom plugin
- esc_attr() on hard coded string
- Creating a return url for getting data from external api
- WP API users per page
- action callback, for action dispatched as reported by hook sniffer, not called
- variable created in page.php is null inside of header.php
- Access WordPress Tag Function From Modal