Any thoughts/advice very appreciated.

Don't optimize prematurely. :-)

Seriously, summing ~10K rows from a database using a while/+= combo takes fractions of a second on my 1.8GHz ... plenty 'quick' for me.

As for a MySQL solution, see SUM().

    --k.