Reduce number of SQL queries inside WP_Query loop to fetch author data

After a lot of trial and error I learnt that WP_User_Query takes an argument fields which can be set to 'all_with_meta'. This reduces number of queries to two for any number of users that are fetched in a single go and also provides benefits of caching. Usage would look like:

$user_query = new WP_User_Query( array('include' => $post_authors, 'fields' => 'all_with_meta') );

Related Posts:

  1. Getting all user metadata from user
  2. How to add custom query filters in WP_User_Query
  3. Searching user meta using WP_User_Query
  4. Query wp_usermeta alongside wp_users
  5. WP User Query get all authors with last name starting with specific letter
  6. How to properly use AND / OR in custom search
  7. Random users always showing same 8 users
  8. How to do WP_User_Query for Nested Array value Inside Nested Array field
  9. How to query 5 users in random who have published more than 10 posts
  10. WP_User_Query not searching numbers?
  11. Query Users by post count, last 30 days and display each users post count according to post type
  12. Get all user with both meta_value
  13. Wp_User_Query not sorting by meta key
  14. WP_User_Query with combined meta query – not working?
  15. SQL query equivalent to WP User Query
  16. Filter user list that meta_value is empty
  17. SQL User Query by Multiple Roles using PHP
  18. WP User Query fails when searching meta queries and search columns
  19. WP_User_Query unable to retreive all user at once
  20. Sort users by “birthday” using WP_User_Query
  21. Minimize database queries to user tables?
  22. Query users by capability – uninstall/deactivate callback
  23. How to display specific posts with WP_Query?
  24. Hide Administrators From User List except current user (administrator)
  25. WP_User_Query pulling ACF to loop
  26. WordPress search posts by author name with autocomplete
  27. pagination with numbers for WP_User_Query
  28. How to display user order by role
  29. Import wp users via one click demo option
  30. Meta_query on same meta key, with diffrenct values
  31. Dynamic User Id
  32. Get users that likes the post
  33. Passing args to WP_User_Query am I using meta correctly?
  34. Randomize Users
  35. Prevent author bio page from showing in search results
  36. WP User Query with Custom Fields and Search Results
  37. Get multiple users with meta value in one query and populate WP_User class
  38. Display if author page is author page of current user
  39. array of meta values using WP_User_Query
  40. Get user first name from custom endpoint
  41. Display the line breaks in user bio without using html
  42. WP_User_Query and user posts
  43. construct complex queries with WP User Query
  44. Storing an array of objects related to each user
  45. Create one-use post dynamically, add to main query, do not insert post (user profile view)
  46. query post by author gender
  47. WP_User_Query orderby meta_val_num
  48. Query to get last posts from authors of blog
  49. WP_User_Query not searching
  50. Replace wp_query with wp_user_query
  51. Query pages created by deleted users
  52. Counting instances of words in the results of a post query
  53. Query posts by post type, author and post meta
  54. SQL to join u3g_users & u3g_meta_value with repeating data
  55. Getting user data via ajax
  56. WP_User_Query Orderby Not Working
  57. Unusual high query of user meta data
  58. Set “editor” role to existing user
  59. How to query users by post count no less than 10
  60. using custom meta user data to run queries in WordPress
  61. Merge wp-query and get_users
  62. Get all wp_users sort by metakey
  63. Logging search queries for logged-in users
  64. Best way to query posts and order by relevancy to query
  65. List users by Year of Birth using a foreach loop to dynamically populate years and data
  66. Show subscriber id in loop
  67. Extend WP_User_Query or WP_User to return all custom fields?
  68. WP_Query within save_post doesn’t include the item that triggered the action?
  69. Search Functionality broken by the wp 4.2 update
  70. Sort users by custom user meta value
  71. How ‘secure’ are loops?
  72. Get users query makes the site loading time too big?
  73. Extend user search in the Wp backend area on the users.php page to allow for searching by email domain and role from the “users search” input box
  74. WordPress WP_User_Query ignores the `meta_query` when called from an Ajax function
  75. Single loop for wp_query and wp_user_query
  76. Filter wp_query to search post title in function
  77. Two queries on the same page with pagination
  78. Best approach to create Hot and Trending sections
  79. get complex results set according to category structure
  80. Setup of taxonomy term template pages
  81. Ignore post by meta value in the main query
  82. Display posts in 3 days chunk
  83. WP_Query’s “request” SQL Query
  84. is_search was called incorrectly
  85. Empty tax_query array returns an empty array
  86. Sorting By Custom Posts With Attachments
  87. Why isn’t my `meta_query` array functioning properly?
  88. Multisite pagination issue by multi query archive 404
  89. WordPress SQL Issue not returning correct reselts
  90. Hide elements outside loop based on query
  91. Combine 2 WP_queries into one (OR relation)
  92. One WP_Query that always shows 1 post from category X and 1 post from “not in category X”?
  93. get_posts query matches too many results
  94. Sort by custom field that is an array?
  95. Multi line of $wpdb->query just run 1 time and end the loop right after
  96. Sort posts on custom field AND after that sort on date?
  97. display the children of the post using the current page as the main parent
  98. In Product Category archives how to show Posts having same/similar prod_cat slug structure?
  99. Custom WP_query in Jnews theme returns thousands of posts
  100. wp_query, calculate with two dates when ‘key’ is text format