How to implement a persistent 'rank' for a leaderboard - looking for for some big brain thoughts

Hi all,

We have a leaderboard as part of our game that we are developing. Currently the ‘rank’ is based on your position on the leaderboard which is determined by a sort function on a specific column which relates to in-game spend.

As we want to add more functionality to the table (such as searching for your web3 wallet address) naturally the ‘rank’ which is determined by your position in the table will change.

So I’m trying to brainstorm some persistent rank ideas without needing to repeat over the whole database and change a ‘rank’ field in the DB for every person.

Appreciate any forum input!

Thanks