List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:September 1 2010 9:19pm
Subject:Re: Best method to keep totals
View as plain text  
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 <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
> 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
>
>
>
>

Thread
Best method to keep totalsTompkins Neil1 Sep
  • RE: Best method to keep totalsJerry Schwartz1 Sep
    • Re: Best method to keep totalsTompkins Neil1 Sep
  • Re: Best method to keep totalsJangita3 Sep
    • Re: Best method to keep totalsArthur Fuller3 Sep
      • Re: Best method to keep totalsMark Goodge3 Sep
        • Re: Best method to keep totalsArthur Fuller4 Sep
          • Re: Best method to keep totalsNeil Tompkins5 Sep
            • Re: Best method to keep totalsTompkins Neil6 Sep
RE: Best method to keep totalsJan Steinman2 Sep
  • RE: Best method to keep totalsJerry Schwartz2 Sep
    • Re: Best method to keep totalsJan Steinman3 Sep