Website slow down with Badgeos

Hi @webexpert10

Can you please elaborate the issue a bit more.
?

• How many users do you have on your site?
• What BadgeOS add-ons you are using on your site?
• Do you use cache plugin on your site?

Thanks?

I have the same problem . When we update to 3.3 the website is so slow we have to wait at least 2mins to move around.
We have rolled back to 3.2 which is ok

We are using Badgeos for Learndash addon as well.
We use W3 Total Cache
We also have about 24,000 users registered , but we have about 2000 active users per month.

Only staging site does the same thing as well.

Tony

Hi @tonygilgilpin

We are going to release a new version of the plugin which will fix the mention issues.

Thanks

Hi
Any news on the later version to solve the problem yet ?

Tony

Our site is basically unusable. We have thousands of students accessing it and it takes several minutes just to login. School started today for the spring semester and students are having a lot of trouble. Per our hosting site “It looks as though there’s a mysql SELECT query that is occurring an excessive amount of times to the wp_usermeta table, this occurring in tandem in application code that’s occurring for a lot of the transaction time as well”

any way to get a quick fix on the plugin?

or, can we roll back to a previous version?

Hi @nightowlaz

We are going to release a new version by tomorrow which will fix this issue. However, you can replace below code in the BadgeOS plugin file for a quick fix.

/wp-content/plugins/badgeos/includes/shortcodes/badgeos_achievements_list.php line 22 to 26

From:

$users = get_users();
$user_list = array();
foreach( $users as $user ) {
$user_list[ $user->ID ] = $user->user_login;
}

To

global $wpdb;
$user_list = array();
$users = $wpdb->get_results( "SELECT ID, user_login FROM {$wpdb->users}" );
if( $users ) {
foreach ( $users as $user ) {
$user_list[ $user->ID ] = $user->user_login;
}
}

Thanks

yes, that worked like a charm! Thank you!

Hi @nightowlaz @tonygilgilpin @webexpert10

We have just released a new version of the plugin which has fixed this issue. Please update the plugin to the latest version.

Thanks

Hi All

Since we have not heard from you in a while, we are now closing this thread. If you still need help, don’t hesitate to let us know.

Thanks