Sum operation with 1MM rows

Hi everyone,

I would like to know how Bubble is performing to do math operations.
As an example: “Do a search for” Value field 'Sum

Considering that this search will have 1 millions rows as a result and I only need the result as a text element with the result of the sum of the field “value”.
I do not need a list with each row and all your fields and details.

Is this a performance issue for Bubble’s server? Or for end user’s device?

I’m also concerning how "group by will perform for doing long periods of analisys, as an example returning as a result an especifc agregattion for the last 10 years of records, supposing that this will represent 1 million plus rows of data to do the agregattion.