Which way to calculate the amount in the database is better and more promising for a large volume?

Question

PHP

The question seems to be simple, but I have not yet understood and have not found an answer for myself.
We have, for example, a database of, for example, several tens of millions of records.
And in each entry, a random number up to 10k.
How actually it is better to calculate the sum of these numbers and with a smaller load?
On the php side in the loop or on the sql side in the query itself?

Answer 1

Stop doing bullshit and start storing aggregates in the database

Answer 2

Naturally, in SQL.

Answer 3

Let's complicate the question: the base lives on a separate server, the channel to which is 1 Mbps and we will try to answer the original question in such conditions.