sql存储过程与代码，对于海量数据，哪一种更好 [关闭]

SQL存储过程与代码：海量数据处理的比较

sql
CREATE PROCEDURE CalculateTotalAmount
AS
BEGIN
    SELECT UserId, SUM(TransactionAmount) AS TotalAmount
    FROM Transactions
    GROUP BY UserId;
END;

python
def calculate_total_amount(transactions):
    user_total_amount = {}
    
    for transaction in transactions:
        user_id = transaction['UserId']
        amount = transaction['TransactionAmount']
        
        if user_id in user_total_amount:
            user_total_amount[user_id] += amount
        else:
            user_total_amount[user_id] = amount
    
    return user_total_amount