IMNSHO, never store dynamic data in a field unless you absolutely have to.
There are going to be exceptions, but unless a manager is going to participate
in hundreds of thousands of fixtures I don't think this is one of them.
Regards,
Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
E-mail: jerry@stripped
Web site: www.the-infoshop.com
>-----Original Message-----
>From: Tompkins Neil [mailto:neil.tompkins@stripped]
>Sent: Wednesday, September 01, 2010 4:29 PM
>To: [MySQL]
>Subject: Best method to keep totals
>
>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
