Title: User Database Performance
Last modified: May 3, 2023

---

# User Database Performance

 *  Resolved [Ross](https://wordpress.org/support/users/rmdglasgow/)
 * (@rmdglasgow)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/user-database-performance/)
 * Hi, I run several sites with large user databases (>200k), and they are struggling
   to cope with generating the user role counts, as the plugin is still using `count_users()`_(
   ln. 146 on woo-wallet/includes/admin/class-woo-wallet-balance-details.php)_.
 * WP 6.0 introduced `wp_is_large_user_count()` and `get_user_count()` to solve 
   this issue. Can the plugin please be updated to use this function instead?
 * You can see how WP now does this here:
   _wp-admin/includes/class-wp-users-list-
   table.php_
 * Thanks!
 * _Reference: 
   **Performance Increases For Sites With Large User Counts (Now Also
   Available on Single Site)**[https://xwp.co/xwp-core-contributor-dev-notes-for-wordpress-6-0/](https://xwp.co/xwp-core-contributor-dev-notes-for-wordpress-6-0/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Subrata Mal](https://wordpress.org/support/users/subratamal/)
 * (@subratamal)
 * [3 years, 1 month ago](https://wordpress.org/support/topic/user-database-performance/#post-16709244)
 * [@rmdglasgow](https://wordpress.org/support/users/rmdglasgow/) Thanks for reporting
   this we will fix this in our next plugin update.

Viewing 1 replies (of 1 total)

The topic ‘User Database Performance’ is closed to new replies.

 * ![](https://ps.w.org/woo-wallet/assets/icon-256x256.png?rev=3360666)
 * [Wallet for WooCommerce](https://wordpress.org/plugins/woo-wallet/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woo-wallet/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woo-wallet/)
 * [Active Topics](https://wordpress.org/support/plugin/woo-wallet/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woo-wallet/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woo-wallet/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [Subrata Mal](https://wordpress.org/support/users/subratamal/)
 * Last activity: [3 years, 1 month ago](https://wordpress.org/support/topic/user-database-performance/#post-16709244)
 * Status: resolved