Hello All,
I was working on some crypto platform. Say the platform has 1000 users with unique & single wallet address for each user.
Any time they can deposit to their address & start using the platform. I will do a cron API Call to blockcypher API & pass each address to get their balance, & update to DB. But it is fragile, as the user grows up, it difficult & slow to update balance & the cron eventually DIES.
Is there any better way 2 update balance & transaction to the platform DB.
we did this method in our site: instead of using unique address for each user, generate addresses for each deposit and tell users to send payment only one time to each address and change address after a successful payment. this way you do not need to check balance of all addresses every time. you just check one when they deposit and then show summary of all addresses balance from db.