We count balance by summarizing orders and this approach is too slow. However we have some ideas.
- First idea is to cache balances and turnovers (it's already done but seems not enough)
- Second is using a log table and update it after each transaction
What are the best practices counting balances in fintech project? Please suggest some solutions of our problem