From: Tompkins Neil
Date: September 1 2010 8:29pm
Subject: Best method to keep totals
List-Archive: http://lists.mysql.com/mysql/222772
Message-Id: <AANLkTine8zxU-Lo1oTS88XXFtx_xK1yBm=YA5LXtGxtq@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=00163630f0e31b7f50048f388d17

--00163630f0e31b7f50048f388d17
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I'm developing a system whereby a manager gets assigned points based a
certain number of factors which are saved alongside a football result.
 However, I also want to keep a total for each manager.  My question is it
best to just have a query that uses SUM to total the managers points gained
for each fixture participated in ?  Or should I be looking to have
a separate field which is the calculated total for each manager ?

Thanks in advance for any advice.

Cheers
Neil

--00163630f0e31b7f50048f388d17--