So I think what you are asking is …
“Do I have to redo all those calculations across multiple tables each time I update something” ?
The answer is probably “yes”. There is no way to have the database automatically update itself, or at least that I know of.
What you can do is have a one custom workflow that rejigs everything. And you could run this “in the background” so to speak.
So you wouldn’t need to do it on every page. You could have a single “function”.
You could schedule this to run at some point in the future.