The Sum Of All Rows: Use PHP or MySQL to Do The Math?

[Firefox Wins]

Which is better / faster / less server load* for adding up the value of all rows in one field:
*Generally speaking: not knowing how many rows.

Use Mysql, into a single $result variable:

Code:

SELECT sum( data_field ) FROM `somewhere`

---

or
Something similar to this*
*html table optional, just asking about the PHP part

PHP Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24

<table border=1> <?php // source = http://www.wellho.net/forum/Writing-PHP/math-in-php-mysql.html $DBhost = "localhost"; $DBuser = "mymy"; $DBpass = "knotpass"; $DBName = "yummydata"; $table = "fred"; $sum = 0; mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable to connect to database"); mysql_select_db("$DBName") or die("Unable to select database $DBName"); $result = mysql_query("SELECT * FROM $table"); while ($row = mysql_fetch_row($result)) { print ("<tr><td>$row[0]</td><td>$row[1]</td></tr>"); $sum += $row[1]; } ?> </table> <?php print "Total is $sum"; ?>

---

• Note: I almost decided MySQL would obviously be faster, and deleted the post, but... Is PHP possibly much better for calculations, while MySQL is optimized for i/o?
  

ty ZB/Y ...and / or anyone else.