Look up all posts by status or meta value – performance difference

As mentioned in the comments, post_status is stored in the posts table but postmeta values are stores in postmeta table which is usually a much more heavy table than posts. Using a meta in db queries, results in adding a JOIN clause to the query to join this heavy table!

So using post_status is definitely a better performance choice.

Related Posts:

  1. Get posts by meta value with date
  2. Is it possible to retrieve a post and its metadata at the same time?
  3. How to save HTML data into SQL post_content column
  4. How do I retrieve the slug of the current page?
  5. Most efficient way to get posts with postmeta
  6. Get posts by meta value
  7. Explanation of update_post_(meta/term)_cache
  8. How to extract data from a post meta serialized array?
  9. How to save an array with one metakey in postmeta?
  10. WordPress is stripping escape backslashes from JSON strings in post_meta
  11. How can I get the post ID from a WP_Query loop?
  12. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  13. How to update_post_meta value as array
  14. Adding meta tag without plugin
  15. What’s the point of get_post_meta’s $single param?
  16. What is the different between an attachment in wp_posts and an attachment in wp_postmeta?
  17. How to edit a post meta data in a Gutenberg Block?
  18. meta_query: using BETWEEN with floats and/or casting to DECIMAL
  19. Sanitizing integer input for update_post_meta
  20. post formats – how to switch meta boxes when changing format?
  21. Execute action after post is saved with all related post_meta records (data)
  22. Lack of composite indexes for meta tables
  23. Get a single post by a unique meta value
  24. if get_post_meta is empty do something
  25. How we get_post_meta without post id
  26. How get post id from meta value
  27. What is the code to get the download link for a product in WooCommerce?
  28. Safe to delete blank postmeta?
  29. advanced custom fields update_field for field type: Taxonomy
  30. update_post_meta not saving when value is zero
  31. Content hooks vs User hooks
  32. Meta compare with date (stored as string) not working
  33. Trying to get custom post meta through Jetpack JSON API [closed]
  34. How to update/insert custom field(post meta) data with wordpress REST API?
  35. Restrict post edit/delete based on user ID and custom field
  36. get_post_meta returning empty string when data shows in the database
  37. publish_post action hook doesn’t give post_meta_data
  38. Remove WordPress.org Meta link
  39. Remove post meta keys
  40. How to access the post meta of a post that has just been published?
  41. Why time functions show invalid time zone when using ‘c’ time format?
  42. Why is get_post_meta returning an array when I specify it as single?
  43. How to update/delete array in post meta value?
  44. How to get all term meta for a taxonomy – getting term_meta for taxonomy
  45. Adding an assisting editor box to Post page
  46. delete unused postmeta
  47. Should I sanitize custom post meta if it is going to be escaped later?
  48. Add post meta based on another post meta value before publish post
  49. How do I retrieve multi-dimensional arrays from the wp_postmeta table, & display on a website?
  50. Front-end update_post_meta snippet displays white screen?
  51. Query between two meta values?
  52. Save both current and new version of post meta
  53. Get Advanced Custom Fields values before saving [closed]
  54. Give extra post-meta to RSS feeds
  55. How to get meta value in wp_attachment_metadata
  56. WP REST API “rest_no_route” when trying to update meta
  57. Clean up output added via wp_head()
  58. List posts under meta_value heading
  59. Why am I getting an infinite loop with have_posts?
  60. get_post_meta – get a single value
  61. delete value 0 in post meta [closed]
  62. Can I safely delete a record, manually, in the wp postmeta table?
  63. How to store post meta in an array?
  64. What action hook updates post meta?
  65. Can’t translate the post meta data (Date) in another language
  66. get_post_meta / update_post_meta array
  67. adding a URL to a post meta
  68. WP Query post meta value
  69. Exclude a category from the filed under list
  70. Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
  71. How do I access post meta data when publishing a new post in Gutenberg?
  72. update_post_meta() not working when used with WordPress action
  73. Using Advanced Custom Field (ACF) to insert meta description on each page
  74. Triple meta_key on custom SELECT query
  75. get_post_custom()
  76. Adding meta data to an attachment post
  77. update_post_meta not adding anything.(Nor add_post_meta)
  78. loop through all meta keys with get_post_meta
  79. How to add meta tag to wordpress posts filter?
  80. Order posts according to user defined order for meta values?
  81. Are multiple values from get_post_meta guaranteed to be ordered?
  82. Identifying Importer Posts
  83. Get updated post meta on save_post action?
  84. Get post from meta_key and meta_value
  85. Add a post metadata if only the key and value does not exist
  86. get_post_meta returns bool(false)
  87. How metadata API works?
  88. Correct processing of `$_POST`, following WordPress Coding Standards
  89. Metabox Data not being saved [closed]
  90. How can I get values using key in Carbon Fields from Multiselect?
  91. Delete post meta conditionally after save post
  92. How to sanitize post meta field value?
  93. Problem With Order Item Meta In Woocommerce
  94. Job of meta_key meta_value fields in database tables
  95. WordPress Action Hooks and Post ID?
  96. Post IDs missing on delete_postmeta action hook
  97. How to store Gutenberg ColourPicker RGBA as metadata
  98. Options to get my custom post type metadata via the WordPress API
  99. Is it possible to update a post meta field through REST API if the format of it when registered is nested?
  100. How trigger to save post when updating post meta