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. Group users by meta field, with name of meta field as group title
  14. Wp_User_Query not sorting by meta key
  15. WP_User_Query with combined meta query – not working?
  16. SQL query equivalent to WP User Query
  17. Filter user list that meta_value is empty
  18. SQL User Query by Multiple Roles using PHP
  19. WP User Query fails when searching meta queries and search columns
  20. WP_User_Query unable to retreive all user at once
  21. Sort users by “birthday” using WP_User_Query
  22. Minimize database queries to user tables?
  23. Query users by capability – uninstall/deactivate callback
  24. How to display specific posts with WP_Query?
  25. Hide Administrators From User List except current user (administrator)
  26. WP_User_Query pulling ACF to loop
  27. WordPress search posts by author name with autocomplete
  28. pagination with numbers for WP_User_Query
  29. How to display user order by role
  30. Import wp users via one click demo option
  31. Meta_query on same meta key, with diffrenct values
  32. Dynamic User Id
  33. Get users that likes the post
  34. Passing args to WP_User_Query am I using meta correctly?
  35. Randomize Users
  36. Prevent author bio page from showing in search results
  37. WP User Query with Custom Fields and Search Results
  38. Get multiple users with meta value in one query and populate WP_User class
  39. Display if author page is author page of current user
  40. array of meta values using WP_User_Query
  41. Get user first name from custom endpoint
  42. Display the line breaks in user bio without using html
  43. WP_User_Query and user posts
  44. construct complex queries with WP User Query
  45. Storing an array of objects related to each user
  46. Create one-use post dynamically, add to main query, do not insert post (user profile view)
  47. query post by author gender
  48. WP_User_Query orderby meta_val_num
  49. Query to get last posts from authors of blog
  50. WP_User_Query not searching
  51. Replace wp_query with wp_user_query
  52. Query pages created by deleted users
  53. Counting instances of words in the results of a post query
  54. Query posts by post type, author and post meta
  55. SQL to join u3g_users & u3g_meta_value with repeating data
  56. Getting user data via ajax
  57. WP_User_Query Orderby Not Working
  58. Unusual high query of user meta data
  59. Set “editor” role to existing user
  60. How to query users by post count no less than 10
  61. using custom meta user data to run queries in WordPress
  62. Merge wp-query and get_users
  63. Get all wp_users sort by metakey
  64. Logging search queries for logged-in users
  65. Best way to query posts and order by relevancy to query
  66. List users by Year of Birth using a foreach loop to dynamically populate years and data
  67. Show subscriber id in loop
  68. Extend WP_User_Query or WP_User to return all custom fields?
  69. WP_Query within save_post doesn’t include the item that triggered the action?
  70. Search Functionality broken by the wp 4.2 update
  71. Sort users by custom user meta value
  72. How ‘secure’ are loops?
  73. Get users query makes the site loading time too big?
  74. 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
  75. WordPress WP_User_Query ignores the `meta_query` when called from an Ajax function
  76. Orderby meta _value that is saved as an array
  77. Complicated `orderby` based on text in custom field
  78. Using a Query Loop Block with Variables (Custom Meta)
  79. Too slow when using both ‘tax_query’ and ‘meta_query’ both in WP_Query
  80. Use of caller_ get_ posts
  81. Tax_query terms ID’s using variable
  82. Order posts by tags count?
  83. Querying Multiple Custom Taxonomy Terms
  84. WP_QUERY returns empty set when fired from a WP-CRON scheduled event
  85. WP_Query, tax_query and term_meta: How to?
  86. How to pass many ids in post__in?
  87. How do I run through a WordPress loop called from a filter function?
  88. slow query – Search for Media Gallery
  89. is_user_logged_in() throwing undefined function error
  90. How to order WP_Query to group results?
  91. Issues with search after added meta_query
  92. Woocommerce: order posts by meta key
  93. Modify query posts
  94. How do I add an item to the WP admin menu?
  95. Multiple meta query from array
  96. show related articles in single.php template
  97. WP_Query to Retrieve Posts from WooCommerce Products that are Only in Catalog
  98. Search Filter With Custom Taxonomy and Custom Fields : How do I handle it via plugin?
  99. Add category and user name to recently updated post list
  100. Main loop querying current template’s info only in custom category archive pages, not my posts