PHP memory friendly alternative to get_posts()

Use the fields argument to grab just the ID – will save you a ton of memory 😉

$product_ids = get_posts(
    array(
        'posts_per_page' => -1,
        'post_type'      => array( 'product', 'product_variation' ),
        'fields'         => 'ids',
    )
);

Related Posts:

  1. Make WP_Query more efficient?
  2. Out Of memory issue on post per page parameter
  3. How to use WP_Query() on single.php?
  4. Exec wp query in slow motion to avoid memory error?
  5. WP_Query (or WC_Product_Query) out of memory
  6. Meta_query compare operator explanation
  7. Reduce or prevent calling of update_meta_cache
  8. Order wp_query by calculated field
  9. new WP_Query() – what is the earliest valid hook?
  10. Extending WP_Query — Optimise SQL query
  11. WP_query and pagination?
  12. How to get post from all Blog Multisite to the Main Site?
  13. Select posts with any post_type from database?
  14. Sort in WP_Query(), not filter? Is it possible?
  15. Better to make new wp_query or only modify main query each time?
  16. Using WP Query to search within ALL keys in meta query
  17. How to display images in related posts?
  18. Search product by brand name in wp_query
  19. What is the difference in a query when using a fieldname as a meta key vs orderby field?
  20. Get all post IDs from current WP_Query – not just currently visible
  21. How to Modify Taxonomy Archive Page with Search Parameter?
  22. WP User Query multiple AND OR query problem
  23. $wpdb->insert inserting two rows in database
  24. More than 1 Year Date Query
  25. Is it possible to dynamically get queried term AND taxonomy?
  26. posts_per_page not working
  27. WP Query for variable taxonomies
  28. WP_query Date Range results not matching loop
  29. Pull post meta with post_query?
  30. How to use WP_Query to display many posts?
  31. $wpdb select date range of posts
  32. Meta Query relation “AND” not working
  33. Complex WP_Query (two post types and multiple operators)
  34. Five posts from a category in footer
  35. Return only post(s) which have post_excerpt
  36. Add quicklink to in the Admin posts page where I can query by a meta_key
  37. Front page with registered query params in URL shows blog archive instead of front page
  38. Order by empty custom field
  39. Cutom wp_query for geolocation search, pagination not working
  40. Warning: Invalid argument supplied for foreach(). when creating a WP_query
  41. Help ordering Post loop by two meta values
  42. Display most popular in the past two days
  43. WP_Query (list) posts according to author’s custom field
  44. New WP_Query loop in admin causes problems
  45. How to sort a custom wordpress query by combination of meta values?
  46. Get author if post has multiple authors
  47. Hide posts with meta key in WP_Query
  48. What happens to the default query when I use WP_Query?
  49. Modifing archive query affects show post count function
  50. For what queries is conditional tags informative?
  51. JSON – Create rest api endpoint for Advanced Custom Fields
  52. Query_vars support in Rest API
  53. Is it possible (and how to) query single Gutenberg blocks?
  54. Continue or break the while loop
  55. Get meta_value of a specific meta_key from all posts belonging to a specific custom type
  56. Custom query filter by ACF date custom field
  57. Nested array issue in meta_query
  58. Query by key or author
  59. Sorting posts by Multiple custom fields in defined order
  60. Why doesn’t my WP Meta Query return any results?
  61. How to build the WP_Query using the code?
  62. How go give $value to wp_query
  63. Show multiple tax_query from 2 or more post_type in a single code
  64. Disable (or limit) queries when certain content (or data) is not needed (or showed)
  65. How to make the ‘request’ filter work?
  66. How to use rewind_comments() – when and how to use it?
  67. How to make a query returning pages from multiple parents
  68. create a custom query for posts managed by Restrict Content Pro
  69. How do I stop the same post showing multiple times in a archive?
  70. Related categories order posts by category
  71. Finding post ID dynamically on click
  72. paginate_links method doesn’t show second page of my custom wp_query
  73. Wp_Query Post per page not working?
  74. Order Element By Custom Field in WordPress
  75. Display All Top Child Categories / Taxonomy
  76. how to get custom attachment url?
  77. ACF Post Object meta-query by title not ID
  78. Case insensitive ORDERBY in wpquery
  79. Sorting with meta_query and multiple, optional meta keys
  80. getting posts by tags
  81. WP_Query & Duplicate entries
  82. Query child posts with tax query on parents
  83. How to break up output of posts for different terms on same page?
  84. Get posts by similar names and categories
  85. Calculating efficiently on large amount of data generated by wp_query
  86. WP Query issue for multiple values
  87. Include post_status check within $wpdb query
  88. Return on a quest all these meta_value
  89. Complicated WP_Query
  90. Filter WP_Query output before it is accessed (pre_get_posts)?
  91. Divide WP_Query posts by date & post type
  92. Custom query to show posts
  93. New WordPress WP Query using posts from certain categories
  94. Taxonomy related query not working
  95. Multiple Orderby is not working right
  96. WP query based on two meta queries
  97. WordPress website links redirect to homepage
  98. Use value from meta key array for use in WP_Query
  99. WP_Query sort by ACF date field (newest first) with blank dates first
  100. Pagination only showed when no category is set in wp_query

Leave a Comment