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. Transform user name before displaying
  79. Using a Query Loop Block with Variables (Custom Meta)
  80. How to remove “MY WORDPRESS”” Label
  81. When should you use WP_Query vs query_posts() vs get_posts()?
  82. When to use WP_query(), query_posts() and pre_get_posts
  83. WP_Query by just the id?
  84. Meta_query compare operator explanation
  85. WP_Query with “post_title LIKE ‘something%'”?
  86. wp query to get child pages of current page
  87. How to get an array of post data from wp_query result?
  88. How to get post id of static front page?
  89. meta_query with meta values as serialize arrays
  90. How to only display posts whose meta_value field is not empty?
  91. Get post ids from WP_Query?
  92. Pagination when using wp_query?
  93. Exclude post ID from wp_query
  94. How to print the excuted sql right after its execution
  95. How to extend WP_Query to include custom table in query?
  96. How to store and receive variables in WP sessions?
  97. Should I use Pre Get Posts or WP_Query
  98. How can i retrieve default post per page value? from settings->reading. And total number of posts?
  99. Nested meta_query with multiple relation keys
  100. Is it necessary to use wp_reset_query() in a WP_Query call?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)