Improve speed of calculations
Opened this issue · 0 comments
morremeyer commented
We can improve the speed of calculations as follows:
- Research if we can use shopspring.decimal together with storing numbers as int only (probably by storing the exponent separately or even using fixed point?)
If not:
- Store numbers as integers only
Then, calculations can be done by the database with e.g. SUM()
operations and the results only need to be transformed. This should increase performance by enabling us to use fewer queries, e.g. when calculating the month sums