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 functions

1. 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 desc

3. 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 desc

I 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

• This topic was modified 2 years, 9 months ago by 1jd123.