myCRED_Query_Leaderboard->get_results() is SLOW

  • Resolved SeeingBlueS2

    (@seeingblues2)


    10 years ago

    It’s almost taking a full second for this query to run:

    SELECT wp_users.ID, wp_users.user_login, wp_users.display_name, wp_users.user_email, wp_users.user_nicename, wp_users.user_url, wp_usermeta.meta_value AS cred
FROM wp_users LEFT JOIN wp_usermeta
ON wp_users.ID = wp_usermeta.user_id
AND wp_usermeta.meta_key = 'mycred_default'
WHERE wp_usermeta.meta_value > 0
ORDER BY wp_usermeta.meta_value+1 DESC ;

    I have almost 400 members so that’s not a big surprise I suppose, BUT why does this query run on every page? I am not using the leaderboard widget anywhere yet it insist on running this long query even on my homepage.

    https://www.ads-software.com/plugins/mycred/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author myCred

    (@designbymerovingi)

    Hi.

    Are you using the My Balance widget? If you are, did you select to show a users leaderboard position? If you have then this query is run.

    Thread Starter SeeingBlueS2

    (@seeingblues2)

    No, the only place it list the balance is in the profile dropdown(using buddypress). No widgets.

    Plugin Author myCred

    (@designbymerovingi)

    But are we talking balance or leaderboard position now? Are you showing the users leaderboard position together with their balance?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘myCRED_Query_Leaderboard->get_results() is SLOW’ is closed to new replies.