Aggregating sums
Suppose I have a large number of transactions, and I would like to maintain the sum of all transactions (say expenses).
Does convex handle this in a way that may run into the limits (e.g. each update may require scanning the entire history), or does it automatically recongize that for a new transaction, it can simply add to the last snapshot?
Also, if I added the functionality for aggregation after there are already some transactions, will convex help to ensure that the data is correctly backfilled?
Thanks!
