Calculating sum of numbers in an Attribute of collection, limit of 25

By default appwrite limits query to 25 items for better performance, what's the way to calculate sum of numbers in each document. I have a finance demo app with 500 entries, need to sum all numbers but default appwrite query get 25 items, I can put 1000 limit in Query.limit but won't that affect performance?

Is there a way to solve this?

I don't know if this is the best way of solving it but to do something similar I created a function with a trigger on documents that kept a running total in a different collection

Until aggregation functions are added I can't think of another way of doing it