Horrible Performance of users.php
-
Dear all,
i fell in love with your plugin and all the functionalities but since i got a good amount of members my backend page is too slow. While i was investigating the cause of this slowdown i saw that several functions of your plugin slows down the users.php page by about 15 seconds.
Unfortunately i can not append pictures but i can name the functions1. count_users() – 5 seconds
2. 4 seconds
SELECT SQL_CALC_FOUND_ROWS gowp_users.ID FROM gowp_users LEFT JOIN gowp_usermeta ON ( gowp_users.ID = gowp_usermeta.user_id AND gowp_usermeta.meta_key = 'account_status' ) WHERE 1=1 AND ( ( gowp_usermeta.user_id IS NULL ) ) ORDER BY user_registered desc3. 4 seconds
SELECT SQL_CALC_FOUND_ROWS gowp_users.ID FROM gowp_users LEFT JOIN gowp_usermeta ON ( gowp_users.ID = gowp_usermeta.user_id AND gowp_usermeta.meta_key = 'account_status' ) WHERE 1=1 AND ( ( gowp_usermeta.user_id IS NULL ) ) ORDER BY user_registered descI really do not need the count user function and the ability to see if the account is approved or not. But 15 seconds to load the users.php is a way to long
-
Thanks for your reply.
You can try this code snippet together with a change to the UM function call to WP for counting the number of users via UM cache instead of a DB query:
Change line 337 in
/plugins/ultimate-member/includes/core/class-query.php
from
$result = count_users();
to
$result = count_users( 'um_cache' );Install this code snippet to your active theme’s functions.php file
or use the “Code Snippets” plugin.add_filter( 'pre_count_users', 'pre_count_users_by_um_caching', 10, 3 ); function pre_count_users_by_um_caching( $null, $strategy, $site_id ) { if( $strategy != 'um_cache' ) return null; $result = array(); $result['total_users'] = 0; $array = array( 'approved', 'rejected', 'awaiting_admin_review', 'awaiting_email_confirmation', 'inactive', ); foreach( $array as $status ) { $result['total_users'] += intval( UM()->query()->count_users_by_status( $status )); } return $result; }Changed nothing. I totally do not understand why there is no fix in your plugin? I mean if i deactivate it, my users.php page is loading in like 1 second. Isnt there a possibility to deactivate everything ultimate member is doing on the users.php page?
The topic ‘Horrible Performance of users.php’ is closed to new replies.
