Thanks for your quick response. So like I thought, I'll just calculate the
totals on the fly and like you mentioned the manager is going to participate
in 50 games per season, with a season being twice per year.
Thanks for the help.
On Wed, Sep 1, 2010 at 10:06 PM, Jerry Schwartz <jerry@stripped> wrote:
> 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
> in hundreds of thousands of fixtures I don't think this is one of them.
> 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
> >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
> >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.