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. Neil On Wed, Sep 1, 2010 at 10:06 PM, Jerry Schwartz <je...@gii.co.jp> 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 > 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: je...@gii.co.jp > Web site: www.the-infoshop.com > > >-----Original Message----- > >From: Tompkins Neil [mailto:neil.tompk...@googlemail.com] > >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 > > > >
