Which meta_query and post_content blend is better in WP_Query, performance wise?

Why would you need tag__in for option 2? You’re not searching for multiple values, only your 1 or 0. In which case, options 2 and 3 amount to the same thing behind the scenes: a taxonomy query. This way would likely be the most performant, but that said, if you don’t want to mess the taxonomies, you can check for empty post content with a filter.

Related Posts:

  1. order by numeric value for meta value
  2. numberposts? showposts? posts_per_page?
  3. $GLOBALS[‘wp_the_query’] vs global $wp_query
  4. Some doubts about how the main query and the custom query works in this custom theme?
  5. Set Alias for meta_query arguments in get_posts()
  6. How can I use order_by to order by two meta_keys without excluding posts that don’t have those keys initialized?
  7. Loop within a loop?
  8. How to query only for products with status “in stock” in WooCommerce? [closed]
  9. Does WordPress sanitize arguments to WP_Query?
  10. How to get posts in different language from WPML Plugin [closed]
  11. WP_Query meta_query where meta value ends in space
  12. Highlighting Sub topic in a post?
  13. wp_query for the first sticky, then display the rest of the posts excluding the first sticky
  14. How to get any tag ID
  15. WP_Query with many meta_query arguments taking a long time to load
  16. Slow speed and high CPU usage for my code. How to improve it?
  17. Multiple queries on Home Page – page load/site speed issue
  18. WordPress custom archive page
  19. query attachments of parent page if attachments of current page are smaller than …
  20. Show all parents and children in custom post type in right order
  21. Why is this coming back as null? Thats wrong. There is one post
  22. Retrieve featured image (thumbnail) url from multiple posts with one query
  23. WP_Query tax_query problem
  24. Only display authors who have posts
  25. Retreaving all images attached to current post
  26. wp_query() get_col error
  27. Update Loop with Form
  28. How to select posts from one category but exclude posts in another category?
  29. Query Custom Post Type Order By Taxonomy Field
  30. Order a query result by a numeric meta key even if it does not exist, but put the posts with meta key first
  31. How can you get first post, last post and post count in a category?
  32. WP_query posts closest to todays date
  33. Setting get_queried_object
  34. difference between like ‘%%%var%%’ and ‘%var%’
  35. WP Query Category Atribute Not Working
  36. Sort query by author: 1 author, then others
  37. How to orderby multiple meta fields if some fields are empty
  38. WordPress custom post type with meta – how to retrieve with wp_query
  39. Order by meta value (numeric value lower to higher)
  40. Wp_query calculate points
  41. WP Query – Outputting JSON and normal loop of posts
  42. get data match with extra field value using wp_query for custom post
  43. Custom query: Get all posts that are from a certain category?
  44. WP_Query for a taxonomy with different taxonomy types
  45. Append URL query to next post link in custom query
  46. How to compare a date in custom field with today’s date in custom WP_Query?
  47. Meta Query doesn’t works as espected
  48. Executing query_posts after wp_insert_post
  49. Shortcode for custom query not returning results when attributes are added
  50. wp_query is showing posts from other categories
  51. Multiple wordpress queries with nested output (odd – even)
  52. Get posts in taxonomy randomly
  53. Page navigation doesn’t seem to work when I add offset?
  54. it’s possible make a WP_Query with math operations?
  55. show posts with range meta key
  56. Using a Shortcode to List Posts from Multiple Categories
  57. is_404() – where does this get set?
  58. wp_query on page template not working (Genesis framework)
  59. WordPress | WP_Query does not return anything with s=a
  60. WP_Query Pagination
  61. Using Ajax and WP_Query to load more posts on category page fails
  62. I have problems with the search query using multiple post types
  63. WP_Query random ordering not working since 5.4
  64. Where my home page and font options has gone?
  65. meta_query compare > not working
  66. 404 page on custom search pagination
  67. WP_Query about meta_key and its array value
  68. Query string order by custom field
  69. Paging works correctly on local version, but not live?
  70. Create global array to compare inside a query
  71. How to add in WP_Query to every 3 posts displayed? [duplicate]
  72. Paginate nested query of child posts
  73. Hi , i am trying to set the post for 24 hours and with it will be changed
  74. Own query vars are not displayed
  75. Show full category tree for a year with all post titles?
  76. Get Current CPT taxonomy category in shortcode
  77. Display images with same specific value?
  78. Sort Posts with custom meta key by default which is currently set as optional
  79. wp_query pagination links producing 404
  80. How return normal search result using wp_ajax action for wordpress
  81. Custom post types loop on a page template
  82. Pagination problem with multiple loops on the same page
  83. WP_Query – meta fields numeric
  84. How to query posts from single post format on Genesis framework
  85. WordPress extremely slow when using get_posts with multiple meta_query relations
  86. Refresh wp_query with no changes
  87. SQL query into to WP query
  88. WordPress WP_Query Search (‘s’) With Multiple Search Terms
  89. I want to place a post before all others from an ACF boleen field
  90. Search results stuck on page 1
  91. How to put posts with some taxonomy on top of others in `pre_get_posts`
  92. wp_query, calculate with two dates when ‘key’ is text format
  93. Use value from meta key array for use in WP_Query
  94. WP_Query sort by ACF date field (newest first) with blank dates first
  95. Pagination only showed when no category is set in wp_query
  96. taxonomy-{term}.php terms pagination returning 404 after a certain page
  97. Using WP Query, I want to include all posts in category 1 as long as they are not also in category 2
  98. Prevent URL Parameter Affecting other WP Query
  99. Sort by multiple columns using get_posts
  100. WP_Query filter Posts by timestamp event (range start and end) and by month (next 12 month)