Add indexing to meta_value in wp_postmeta

Don’t limit the field, instead, limit the index, e.g.

ALTER TABLE wp_postmeta ADD key(meta_value(100))

This limits the index to the first hundred bytes of meta_value.

You’ll probably want an index on post_id, meta_key, meta_value for joins. How much of meta_key and meta_value is required depends on your data, for example

ALTER TABLE wp_postmeta ADD key(post_id, meta_key(100), meta_value(100));

Whether that helps with your query is another question. Get the SQL generated with $query->request and then run it with “EXPLAIN $SQL” to see how MySQL handles it, which indexes are used etc pp.

Related Posts:

  1. What is an efficient way to query based on post_meta?
  2. database query with more than a couple meta hangs and doesn’t complete
  3. How to set up hierarchical relationships without using plugins / meta query
  4. 294 Queries on Mainpage of WordPress
  5. WP_Query by meta key not returning any posts
  6. WP Query Args – Title or Meta Value
  7. how to show posts that are missing a meta_value
  8. Does tax_query really beats meta_query in all situations?
  9. WP_Query using meta_query with relation OR and orderby meta_value doesn’t work
  10. querying with custom meta field with meta_query
  11. Order by two meta keys
  12. multiple meta key but get server load is very high
  13. A WP_Query that will look for posts after 2 weeks ago OR with a certain meta value
  14. Order by meta_value_num DESC and meta_value ASC on WP 4.0
  15. Query by meta_key and order by meta_value_num return orderby date
  16. WordPress altering my custom query, How to fix it?
  17. Order by meta_key in custom post type doesn’t affect the query
  18. How to create/modfiy WP_Query to search in post title OR custom field?
  19. Use meta_query to display events by date in custom field
  20. How to show recent and upcoming birthdays using meta_query
  21. Order Posts by meta value AND published date
  22. Using WP_Query and WP_Meta_Query Outside of WordPress
  23. What format does the meta_query TIME type require?
  24. How WordPress attaches its Featured Images with posts?
  25. If two first numbers exist in wp_meta_query value
  26. WP_Query on custom field and order results
  27. WP_Query filter and order by meta ordering by wrong joined table
  28. WP_Query last five posts, simply ordered by meta_value
  29. Tax query clause inside a meta query clause?
  30. What is the random string I am seeing when I use get_query_var?
  31. Optional Meta Query
  32. How do I make a meta_query OR relation work? [closed]
  33. Meta_query on same meta key, with diffrenct values
  34. Can we return all category (not post) with Custom Query Filter? [closed]
  35. Extend product search with meta in WooCommerce
  36. how to make members list directory through wordpress post custom meta key.
  37. Changing sort order for presentation by Jetpack infinite scroll
  38. get posts by meta_key from inside key of post meta
  39. Help optimizing slow WP_Query with meta_query
  40. meta_value_num not ordering all items
  41. Meta Queries – should nesting work after WP 4.1?
  42. Filter and Order by Multiple Custom Meta Values
  43. Meta Query relation “AND” then set array accordingly
  44. WP_Query with meta_query dosen’t return results
  45. Query with meta_query and tax_query together not working properly
  46. Is it possible to query from external database? [duplicate]
  47. Is it possible to query a custom field where the value is between two fields?
  48. Filter posts by comparing custom meta value against postdate
  49. How to provide meta_key array to wp_query?
  50. Specify strict ‘order by’ in WordPress query
  51. meta_query fails to compare on values containing apostrophes
  52. Does WordPress have something like Drupal’s DB API?
  53. Check if searched number is within the post meta value
  54. Meta query compare for ID’s greater than specific ID
  55. Is it possible to add relation between meta_query and tax_query?
  56. WP Query – filtering terms with regex
  57. add_query_arg to compare and display events from a certain date
  58. Show single posts date, in a page of posts
  59. Issue with data array format
  60. WP_Query Class custom field parameters
  61. meta_query where the meta value is not the post title
  62. Order WP_Query by meta_key priority when ‘OR’ relation used for multiple meta values
  63. Query on meta values and post title
  64. Custom Meta Query doesn’t work the same on two site
  65. meta_query with meta values as serialize arrays
  66. WP Query – grouping posts by same meta key, adding together values from another key
  67. Woocommerce Get Orders By Meta Value
  68. meta_query is overriding default search
  69. Multiple WP_Query args combinations according to post type
  70. WP_Query multiple value not working
  71. Query for current post
  72. wp query search multi terms
  73. WP_User_Query Orderby Not Working
  74. Translating WP query into to SQL query
  75. Unusual high query of user meta data
  76. WordPress Query optimaization for slow query
  77. WP_Term_Query->get_terms() very slow query for WordPress filter
  78. Meta query doesn’t remove placeholder escape before query
  79. WP Query Meta Query
  80. Query custom meta value – post view and date meta
  81. What is the best way to reset a search on a meta_key / meta_value?
  82. Slow query when selecting with large meta query or post__in
  83. How can I modify standard search query to include also ACF custom fields values?
  84. Custom WP_query and integrating into theme file
  85. WP_Query – show posts where meta value and user_email match
  86. WP Meta Query at depth 2
  87. Best way to Order Post in Home without a plugin
  88. WP_Query using meta_query with LIKE doesn’t return what it should
  89. Website goes slow down after importing long database
  90. Is there any difference between below WP_Query code snippets?
  91. Return a single custom post from multiple meta queries
  92. Sorting: custom query with orderby meta_value_num THEN by title
  93. query post based on comparison
  94. Including ‘cat’ => $cat breaks meta_query
  95. meta_query compare not doing what I want it to do
  96. Query string form $_GET[‘value’] is not working as meta value in wp_query
  97. WordPress extremely slow when using get_posts with multiple meta_query relations
  98. SQL query into to WP query
  99. Use meta query only 3 or more results?
  100. Use value from meta key array for use in WP_Query

Leave a Comment