How to stop wp_postmeta from being called on archive and search pages?

add_filter('pre_get_posts', 'customize_query');
function customize_query($query) {
    if($query->is_main_query() && ($query->is_search() || $query->is_archive()) {
        $query->set('update_post_meta_cache', false);
        $query->set('update_post_term_cache', false);
    }
}

Then wordpress will make 2 less queries for those pages & then you can use the $wpdb object to write custom queries.

Related Posts:

  1. Optimize WP Meta Query for large amount of post meta?
  2. Meta compare with date (stored as string) not working
  3. How metadata API works?
  4. WP_POSTMETA – What do these values mean inside the data structure?
  5. What type of index should I use for postmeta?
  6. How to create a meta_query to get all posts with a specific meta data?
  7. Compare meta_query with a Regular Expression and do a less-than operation on it
  8. $wpdb class updating meta_value using Ajax [closed]
  9. cleaning up safely wordpress wp_postmeta table
  10. Should I save this mulit dementional arary as one post meta?
  11. How to check if a post meta key/value pair already exists for a specific post
  12. get Insert id for meta field
  13. Filter posts by meta key
  14. Search post overlapping dates – meta_query with meta_key
  15. How can I query for posts using a date stored in post-meta?
  16. I can not display meta value in extras.php and template-tags.php
  17. Negative meta_query if storing multiple post_meta values with shared meta_key
  18. How to get posts by meta value as multi-dimensional array?
  19. Combine meta query and give a specific meta query a higher priority
  20. Is there any way to get all custom posts and all custom terms with it’s meta in few queries?
  21. Multiple meta key and value search in the query
  22. Multiple postmeta values to the same post_id/meta_key combination?
  23. Retrieve posts from meta key
  24. How to show specific meta keys of all posts in admin panel?
  25. How to create a link for wordpress meta datas?
  26. Cache metadata for set of posts
  27. How we insert values into database using metabox WordPress?
  28. Check if Post Title exists, Insert post if doesn’t, Add Incremental # to Meta if does
  29. How to update/insert custom field(post meta) data with wordpress REST API?
  30. Custom Queries: Joining On Meta Values From Two Custom Post Types
  31. How to update single value in multi dimensional Post Meta?
  32. Front-end update_post_meta snippet displays white screen?
  33. How to get meta value in wp_attachment_metadata
  34. Documentation for post meta
  35. Clean up output added via wp_head()
  36. Comparisson between date() and a date from wp_postmeta
  37. Displaying posts with only upcoming dates according their custom field date value
  38. Get post from meta_key and meta_value
  39. get_post_meta returns bool(false)
  40. How to get custom post type to display post meta on archive pages?
  41. WP_POSTMETA changes site crash
  42. meta_post_meta return value 1
  43. How to use post_id with a Class?
  44. Query metas (and not : query posts by metas)
  45. Set default Custom Post Meta Value
  46. WordPress front-end media (image) upload ERROR!
  47. running function during post save and adding variable to post meta
  48. WP_Query with meta_query for children
  49. how to make members list directory through wordpress post custom meta key.
  50. update_post_meta saves nothing in database when run in publish_post
  51. Can’t access post meta on new post creation (cpt)
  52. Custom post meta values reset by autosave [duplicate]
  53. Is it possible to retrieve a post and its metadata at the same time?
  54. Post meta as array looks like string instead of array
  55. Why does get_transient() always return string even if integer set?
  56. Author_meta ONLY if it exists
  57. How to test the outcome of a wpdb query?
  58. get_post_meta as a list for drop down search filter
  59. WP_Query of custom post type sorted by meta_key has unexpected results
  60. Is there a way to disable post meta caching for development?
  61. update_post_meta not working?
  62. Change wordpress meta tag description using WP functions
  63. Drag and Drop Metadata Menu Order
  64. Cant create or update meta fields using WordPress REST API
  65. Display current ranking of post as a number in post title
  66. delete duplicates wp_postmeta
  67. Post Thumbnail missing when using webp format while sharing
  68. Bulk Update Post Meta Values from Different Post via Rest Api
  69. update_post_meta() is not saving the value
  70. Only show meta on one post type on search results page
  71. How to register post meta with multi level arrays?
  72. Unable to gather Image URL from Custom Post Type’s; Custom Meta Field
  73. If I disable screen options, does WP still try to update post meta?
  74. Can we have duplicate key pair values in post meta data?
  75. I created a Custom Meta Box but it is not displaying the value on my post page
  76. Meta data being pulled from wp-login.php
  77. WordPress Query optimaization for slow query
  78. Get post content before rendering
  79. wp_insert_post inside save_post adds wrong metadata to inserted post
  80. Rename image filename using ‘media_handle_upload’
  81. How do I update a specific value within array in a products metadata?
  82. Update Post metafield of specific categories
  83. Using Self Hosted Video URL With Custom Fields
  84. get_post_meta not work in php foreach
  85. Why are my custom metaboxes not updating the post meta?
  86. How to get meta value based on latest post id with group by term name
  87. Problem serializing single quote and double quote into post meta
  88. Storing post_meta fields in array
  89. Performace on 1 million plus meta fields vs 1 field with 1 million multi array
  90. Fetching array of postmeta with $wpdb and in_array conditional
  91. Piklist File Upload
  92. Return a single custom post from multiple meta queries
  93. how to echo/display the custom field value in specific custom field name?
  94. update_post_meta() not working in bulk option
  95. How to update the ‘modified_time’ of a post ONLY when content is changed?
  96. Multiple If else statements on Search Result Page
  97. How to make certain content of the post noindex and no follow. not entire post?
  98. get_children filter with postmeta
  99. wordpress query making site very slow
  100. if condition from post_meta not working in save_post
error code: 523