List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:October 7 2010 2:34pm
Subject:Fwd: Design advice
View as plain text  
Wonder if anyone can help me ?

---------- Forwarded message ----------
From: Tompkins Neil <neil.tompkins@stripped>
Date: Tue, Oct 5, 2010 at 10:07 AM
Subject: Design advice
To: "[MySQL]" <mysql@stripped>


Hi

I have a number of tables of which I use to compute totals.  For example I
have

table : players_master
rec_id
players_name
teams_id
rating

I can easily compute totals for the field rating.  However, at the end of a
set period within my application, the values in the rating field are
changed. As a result my computed totals would then be incorrect.

Is the best way to overcome this problem to either compute the total and
store as a total value (which wouldn't change in the future), or to store
the rating values in a different table altogether and compute when required.
 If you need table information please let me know and I can send this.

Thanks,
Neil

Thread
Design adviceTompkins Neil5 Oct
  • Fwd: Design adviceTompkins Neil7 Oct
  • Re: Design adviceMySQL)8 Oct
    • Re: Design adviceNeil Tompkins8 Oct
      • Re: Design adviceMySQL)10 Oct