Querying by taxonomy vs Querying by Custom fields Speed Comparison

Taxonomy queries are by default extremely complex relative custom field queries. Without benchmarking I am pretty sure they are going to be slower even if the meta table isn’t indexed, but you can add an index if you want. It won’t effect WordPress at all.

My advice is “use what logically works for the data”. If you have problems, solve the problems then.

Related Posts:

  1. How to _GET multiple value checkbox WP_Query in Custom Toxonomy / Custom Fields
  2. Nested meta_query with multiple relation keys
  3. Meta query with string starting like pattern
  4. WordPress tax_query “and” operator not functioning as desired
  5. compare meta_query in get_posts arguments
  6. Does tax_query really beats meta_query in all situations?
  7. Getting attachments by meta value
  8. querying with custom meta field with meta_query
  9. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  10. search query within custom taxonomy term, post title and meta field
  11. WooCommerce: filter by parent product’s taxonomy and product variation’s meta data
  12. WordPress altering my custom query, How to fix it?
  13. Order by meta_key in custom post type doesn’t affect the query
  14. How to show only one post for each categories of taxonomy of custom post that contains a specific custom field
  15. tax_query shows no results if nothing is selected
  16. meta_key and meta_value not working together
  17. Display link to taxonomy archive only if it has posts with certain custom field values
  18. Order Posts by meta value AND published date
  19. WP_Query, tax_query and term_meta: How to?
  20. Tax query clause inside a meta query clause?
  21. Querying on multiple taxonomies pulled from $_GET checkbox array not working?
  22. How to make Meta Query case sensitive?
  23. How to Filter Posts by Custom Fields?
  24. wp_query check if integer exists in custom field’s array
  25. Fetch Record based on meta key dates
  26. Meta_query with multiple keys and multiple values
  27. Is it a good idea to improve meta query performance by adding tax query?
  28. meta_query BETWEEN, but the range is stored in the custom field
  29. Extend product search with meta in WooCommerce
  30. how to make members list directory through wordpress post custom meta key.
  31. Tax query AND/OR meta query [duplicate]
  32. Large AND OR query timing out
  33. meta_value_num not ordering all items
  34. meta_compare not comparing whole integer
  35. Query with meta_query and tax_query together not working properly
  36. WP_query – Filter by tax_query and meta_query using multiple select
  37. Tax Query only returns for the first of several terms
  38. Display posts with specific value first in query
  39. How to print term name inside wp post loop
  40. Get every post with value in meta key
  41. How to search for meta_query LIKE or tax_query LIKE and grab these posts on search results?
  42. Is it possible to add relation between meta_query and tax_query?
  43. How to restrict search on a certain page to only return results against custom taxonomies?
  44. add_query_arg to compare and display events from a certain date
  45. Comparing 2 Decimal Numbers from custom fields and displaying posts
  46. meta_query weird behaviour, static int will work, but not user data
  47. Query multiple post types, but different order for each
  48. Order by the first array within a meta_query
  49. Query ACF relationship field – Comparator IN – Value array
  50. ACF: How to query for a given value count of an array like field? (e.g.: How many rows has a `flexible_content` field?)
  51. How do i create a custom post query when the meta value is an array?
  52. display ACF repater field in archive page
  53. WP Query – grouping posts by same meta key, adding together values from another key
  54. WP_Query for a taxonomy value OR a custom post type meta field
  55. meta_query is overriding default search
  56. Trouble with serialized metadata
  57. Comparing Meta Field date in WPQuery using Meta_Query?
  58. Getting posts by custom field value
  59. list all post who have mutual taxonomy as current taxonomy!
  60. Query against multiple locations within single custom post type post
  61. WP_Query, ACF field and array
  62. Order by Date Custom Field
  63. Query by meta value (add a dropdown of all values)
  64. Order Posts By Custom Field That is an array of objects
  65. Optimal way to make tags in tax_query optional?
  66. Custom WP_query and integrating into theme file
  67. How can I get all the posts that are related with a specific taxonomy term?
  68. How to combine nested tax_query logic with other nested query logic?
  69. tax_query not working for taxonomy slug
  70. Extending WP Query: Custom geolocation meta values work, but tax_query breaks
  71. Custom query for tag and custom tag from 2 post type
  72. Using custom field as ‘orderby’ value causing post grouping by publish date
  73. How to get hierarchical number of custom taxanomy
  74. Custom loop – Isolating post meta output depending on current query taxonomy terms
  75. WP_Query to show post from a category OR custom field – Not 100% answered
  76. Compare meta key separation
  77. query post based on comparison
  78. Get posts by meta value except one post [closed]
  79. WP Query Conditionally query meta and taxonomy
  80. Custom query with custom filtering returning incorrect results
  81. meta_query ‘compare’ => ‘IN’ not working
  82. Sorting: custom query with orderby meta_value_num THEN by title
  83. The Operator “NOT IN” Does Not Work In tax_query
  84. Meta_query with or without value
  85. How can i make WP_Query return post image and categories?
  86. How to add terms to my tax_query based off of the current post
  87. wp_query not searching with apostrophe
  88. pre_get_posts Remove tax_query Completely
  89. Getting Taxonomy inside WP_Query Loop
  90. Nested tax_query that allows specified categories OR tags, but NOT other categories
  91. Custom query based on meta key – Reduce three states to two in results?
  92. How to display multiple custom fields with the same meta_key in an ascending order?
  93. Loop posts based on permalink term
  94. How to get current page nearest parent id?
  95. Get posts having meta value between two numbers
  96. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  97. WP_Query with Pagination and orderby meta_value_num showing duplicates
  98. WordPress hiding posts without content on custom taxonomy query. How to solve?
  99. query_posts with sorting on a custom datestamp
  100. Display all custom meta field values from the database using ACF Repeater

Leave a Comment