Which is faster -- MYSQL SUM() or make PHP array and use array_sum()

[mrherman]

Hello, everyone:

 

I'm using PHP and Mysql. 

 

I've got a table of that has 30 fields that I need to add together.  I've got to do this for each record, and there are about 10,000 records.

 

Which would be more efficient? 

 

SELECT SUM( field1 + field2...)

or

to make an array for the fields and then use array_sum()

 

Thanks.

[Zane]

SUM() would be faster, unless you're adding other variables along with it... PHP variables.

[mrherman]

Thank you!!