I was just curious to kwow that in a application which revolves around the balance amount is it a better practice to store the balance for each category or is it better to calculate the balance on the fly before saving a new transaction. My business logic of calculating the balance is given in my previous post above.
Thanks.