What is an efficient way to query based on post_meta?

I’d like to see what the actual generated SQL is that WP_Query is using, but for now.

( You can use http://wordpress.org/extend/plugins/debug-bar/ to easily view the SQL query )

Queries ordered by ‘random’ are inefficient. If you don’t need that remove it. If you do need a random order, consider removing it anyway and using PHP’s shuffle to randomize.

LIKE queries are also fairly inefficient. Use = if you can.

You might be faster to write a query of your own that pulls the post IDs out of the postmeta table and then use WP_Query with a simple post__in parameter to pull post content. This may or may not help, but is worth the experiment.

Related Posts:

  1. WP_Query by meta key not returning any posts
  2. Use REGEXP in WP_Query meta_query key
  3. Add indexing to meta_value in wp_postmeta
  4. Getting attachments by meta value
  5. WP_Query not working as expected for attachments and custom meta_query
  6. How can I create a WP_Query that returns posts where one meta_value
  7. WordPress altering my custom query, How to fix it?
  8. WP Meta Query for some meta (array) values
  9. How to get sum of meta_values of a meta_key in wp_query according to conditions
  10. Filter WordPress posts by between parameter
  11. Advanced WP Query hogs the SQL server
  12. Order posts by meta value and Date
  13. How To Get Some Data From WordPress Database Using WordPress $wpdb Query?
  14. Query post with meta_query where date is not in future
  15. Get meta info related to current post
  16. Select from wp_post and multiple meta_value from wp_postmeta
  17. SQL: What is wrong with the following query (generated by WordPress WP_Query, ordering prices)
  18. How to make Meta Query case sensitive?
  19. Performance when getting post meta for post retrieved by meta value
  20. Get attachment by meta_key value
  21. Optional Meta Query
  22. Fetch Record based on meta key dates
  23. how to make members list directory through wordpress post custom meta key.
  24. Changing sort order for presentation by Jetpack infinite scroll
  25. Large AND OR query timing out
  26. database query with more than a couple meta hangs and doesn’t complete
  27. Is it possible to query from external database? [duplicate]
  28. Filter posts by comparing custom meta value against postdate
  29. List of ways to access WordPress database?
  30. How to set up hierarchical relationships without using plugins / meta query
  31. Slow Query On Search
  32. WP_Query: apply an SQL function to meta fileld value
  33. Nested array issue in meta_query
  34. Query posts by searching for a string in a meta field
  35. WP_Query meta compare must include ALL array values
  36. How do i create a custom post query when the meta value is an array?
  37. wp query to use both author id and meta_query
  38. WP Query – grouping posts by same meta key, adding together values from another key
  39. Meta query ignores multiple values of the key
  40. Trouble with serialized metadata
  41. show most viewed post
  42. Why can my filter query SOME metadata but not other metadata?
  43. Query against multiple locations within single custom post type post
  44. Translating WP query into to SQL query
  45. update_post_meta performance in a loop woocommerce
  46. update_post_meta performance in a loop woocommerce
  47. How to set meta_query if get_post_meta returns nested array for that key? [duplicate]
  48. Slow wp_posts and wp_postmeta query using Advance Custom Fields
  49. Saving custom fields for WP_Query to retrieve
  50. How to show all the associated posts with specific date of data metabox?
  51. WP Meta Query at depth 2
  52. Include post_status check within $wpdb query
  53. WP_Query Posts by Metadata from Option Tree
  54. WP Query to order posts by multiple meta fields
  55. Return a single custom post from multiple meta queries
  56. WP_Query with several meta_query-statements and order by meta_value
  57. 294 Queries on Mainpage of WordPress
  58. Meta_query compare operator explanation
  59. meta_query ‘compare’ => ‘IN’ not working
  60. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  61. Sorting: custom query with orderby meta_value_num THEN by title
  62. Using OR conditions in meta_query for query_posts argument
  63. WP_Query with checkbox meta_query
  64. Get posts by menu ID
  65. Meta Query with date and time on the same Day before given time
  66. How to grab metabox value in wp_query meta_query key
  67. How to count post meta key values for all posts in database
  68. WP Query – Get WooCommerce Products with variation that is in stock
  69. Meta_query with or without value
  70. Exporting Data from WordPress into a flat table
  71. wp_query not searching with apostrophe
  72. $wpdb select date range of posts
  73. Custom query based on meta key – Reduce three states to two in results?
  74. Query that loads a custom type AND posts whose ids are not inside those custom types custom fields
  75. How to display multiple custom fields with the same meta_key in an ascending order?
  76. Meta_query with multiple keys and multiple values
  77. Tax query AND/OR meta query [duplicate]
  78. How do I query for posts by partial meta key?
  79. Help ordering Post loop by two meta values
  80. No results found from a $wpdb->get_results() query when trying to join more than one meta key query
  81. How to increase load time of an archive/search page (WP_Query)
  82. Hide posts with meta key in WP_Query
  83. Appending to existing WP_Query’s meta_query if exists
  84. Custom query filter by ACF date custom field
  85. Error in meta_query not get result
  86. How to get current page nearest parent id?
  87. meta_query – check for multiple meta values in key which holds an array of values
  88. Searching for a specific month in a metadata saved as Timestamp (Wp_Query)
  89. How to get meta key list efficiently?
  90. WP_Query on custom key and value
  91. Get posts having meta value between two numbers
  92. Query by meta value (add a dropdown of all values)
  93. Separate by Category Post Type
  94. Calculating efficiently on large amount of data generated by wp_query
  95. WP_Query returns empty if meta_query has more than 7 values
  96. WordPress meta_query not working
  97. Using orderby with 2 meta keys
  98. How to get several fields from wp_query?
  99. query by meta value then date and not empty meta value
  100. How do I have multiple metaqueries inside one wordpress query

Leave a Comment

techhipbettruvabetnorabahisbahis forumuedusedueduseduseduedueduseduseduedu