How much worse is querying custom fields compared to custom taxonomies, quantitatively

The trouble with meta queries is they require an additional join per filter. Say you have a property site, and you’re searching by location, rooms and price. That’s three joins. If you were using taxonomies, just two (terms and term_taxonomy) – no matter how many filters.

The other reason taxonomies tend to beat meta queries is their db schema. They’re well indexed and optimised for searching – the meta table, whilst indexed on meta keys, has a value field that’s large text – start querying on that bad boy (especially LIKE statements) and MySQL will have to take a breath or two.

Having said all that, meta queries have their place and can be extremely useful (with caution). And to be honest, unless you’ve got thousands of posts, or you’re applying several meta queries, the difference will probably be negligible.

Related Posts:

  1. Loop through custom taxanomy in post and display custom fields from posts
  2. Transfer taxonomy to custom field
  3. How to show to show post list under the specific category name using jetengine query?
  4. How do I exclude a custom taxonomy from the post loop
  5. Is ACF being a honey trap? [closed]
  6. Add custom taxonomy fields when creating a new taxonomy
  7. Filtering custom taxonomies
  8. How to modify the query in taxonomy-custom.php to sort term archives by a custom meta field?
  9. Custom Taxonomy not working with posts_per_page in new WP_query (pagination problem)
  10. Get value in custom field with taxonomy [closed]
  11. get_query_var(‘paged’) always returns empty
  12. Custom metabox for menu administration page?
  13. Custom Fields and performance
  14. register_rest_field for custom taxonomy fields that are assosiated with custom post type
  15. Is it possible to sort the post based on a custom field?
  16. Showing posts by collection of specific terms and texonomy
  17. Custom taxonomy – custom sortable column
  18. How to display submenus on page based on referring top-level parent?
  19. How to display posts from a single category within a custom taxonomy
  20. How get custom field from custom taxonomy?
  21. Sorting Posts Via Custom Taxonomy Values Using Checkboxes?
  22. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  23. Taxonomy.php issue with search and filters
  24. How to add custom field to custom taxonomy in 4.4
  25. how to search in custom fields & custom taxonomy for custom search
  26. Getting yoast title for custom taxonomy
  27. Outputting an array of term meta values in a custom WooCommerce tab?
  28. List the number of posts for each custom taxonomy and specific custom field value
  29. Solve product properties with custom taxonomies?
  30. Is it acceptable to build functionality into a theme built for a client? [closed]
  31. $wpdb query a post type within a specific taxonomy term while ordering posts by custom meta value?
  32. Custom fields to taxonomy
  33. Custom fields ‘for’ custom taxonomy?? Can someone explain why?
  34. Print terms with taxonomy and metabox value
  35. Can I use a Custom Meta Value inside of ‘get_the_terms’?
  36. Alter post order on taxonomy template
  37. query_posts and custom taxonomy posts order
  38. How to add contents of a custom field to a taxonomy term list?
  39. How can I hide admin columns showing extra custom taxonomy fields?
  40. Conditional display for custom fields/taxonomy
  41. How do I modify the “Insert Media” lightbox in the admin to only show media items from a category?
  42. quey posts from different categories with taxonomy
  43. I am trying to display information from a custom table from my wordpress users pages
  44. Save custom taxonomy data in different table not in wp_options for my own plugin
  45. How to create a dependent drop-down and options in dropdown must be manageable from admin panel
  46. How to separate posts in loop?
  47. Show all taxonomy’s terms’ posts having another taxonomy’s term in common
  48. Search Tool only refreshes Page without showing results
  49. Removing “s” from search with custom parameters
  50. How to fetch the data from Advanced Custom post when we search specific keyword or field name related to the post?
  51. How do I display a custom field from a custom taxonomy in single.php?
  52. List Posts For Terms Of A Custom Taxonomy For Any Post Type
  53. WordPress implode & wp_insert_post question
  54. how to store values in database at hierarchical view
  55. Best structure for entering recipes in a WordPress theme?
  56. WP REST API – get custom taxonomies based on terms & filter
  57. Using WP_Query and Query_post for the loop?
  58. Copy/clone/associate Custom field to Custom Taxonomy
  59. How to write sql query to get the posts from a custom taxonomy term name
  60. saving meta/custom field to tag
  61. How to support fifteen thousand terms in WordPress?
  62. one post per term taxonomy
  63. Different Taxonomy Values for Each Post
  64. What’s the best way to add taxonomy’s image in 2017?
  65. Why can’t I access Custom Taxonomy metadata?
  66. SQL / wp_update_post: change post custom field to CPT post taxonomy
  67. Filter by Custom Taxonomy AND Custom Field
  68. Insert taxonomy slug into loop class
  69. Extra Meta Data for WordPress Multisite Taxonomy
  70. Taxonomy or Custom Field
  71. Using Custom Taxonomies to organise products – struggling to call a correct list
  72. How to use custom slug and custom templates for custom taxonomy?
  73. Custom field with terms from another taxonomy programmatically
  74. Convert post meta to custom taxonomy?
  75. Group posts in a category based on tags in custom taxonomy
  76. Count tags for current post and save into custom meta field (and update it on post edit)
  77. ACF – Get unique values of array
  78. Remove Custom metabox from particular page template is used
  79. Pre_get_post custom taxonomy combined with custom fields?
  80. Adding a checkbox field to a (custom) taxonomy
  81. Add and Custom category for posts “PAGE”
  82. Is it possible to sort the post based on a custom field?
  83. Reset custom taxonomy meta data after saving
  84. how to filter the data’s comparison operators (>= &
  85. How to add meta fields to custom taxonomy add/edit page?
  86. How to filter a taxonomy meta field to the ‘single_term_title’ filter hook
  87. sort Posts by custom user filed
  88. Register custom taxonomy from a Advenced custom field option page
  89. Use custom field as tag slug
  90. How can I show custom field according to taxonomy?
  91. Custom Fields link to other pages, not search
  92. Taxonomy Extra Meta [duplicate]
  93. How do I query multiple specific posts from a custom taxonomy?
  94. Can you orderby slug in a taxonomy archive page using WP_Query?
  95. Any way to make custom taxonomy field searchable?
  96. Advanced WordPress search form based on custom taxonomy and custom meta value
  97. query posts returns 10 records
  98. More than one Hierarchical Taxonomy and SEO
  99. Getting taxonomies specific to categories
  100. Group custom taxonomies based on tags contained in their posts