[Zope] Summing ZSQL Column Values

Tim Wilson wilson@visi.com
Tue, 24 Jun 2003 11:29:03 -0500


abg@comco-inc.com wrote:
> What is the most efficient method of iterating through ZSQL rows and
> displaying the sum of a specific column?

Why not use your DB to calculate the sum? My strategy is to let the DB 
do as much work as possible. I figure, perhaps naively, that will 
produce the best performance most of the time.

-Tim

-- 
Tim Wilson
Twin Cities, Minnesota, USA
Science teacher, Linux fan, Zope developer, Grad. student, Daddy
mailto:wilson@visi.com | http://qwerk.org/ | public key: 0x8C0F8813