Faster way to get all users balance?

  • Resolved robdrewjeffrey

    (@robdrewjeffrey)


    3 years, 11 months ago

    I have a site with 3000+ accounts and now the wallet admin page that shows all the users balances takes almost 60 secs to load.

    I tested another method where i loop through all users and request their balance:
    $funds = (float)woo_wallet()->wallet->get_wallet_balance($user->ID, 'number');

    But that still takes the same amount of time as the wallet admin page.

    Is there a faster way to do this? It seems like it shouldn’t be loading this slowly at only 3000 entries.

    Thanks for your help guys, hopefully I am missing something obvious.

    Rob

Viewing 1 replies (of 1 total)
  • Plugin Author Subrata Mal

    (@subratamal)

    @robdrewjeffrey Sorry for this. But we don’t have that much data to test in our local environment. But we have a database query results cache system inbuilt into our wallet. But for sure there must be other enhancement processes but for that, we need a large amount of data. Could you please reach out to our support email [email protected] regarding this?

Viewing 1 replies (of 1 total)
  • The topic ‘Faster way to get all users balance?’ is closed to new replies.

Tags