Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Tompkins Neil (neil.tompkinsgooglemail.com)
Date: Thu Oct 07 2010 - 09:34:58 CDT
Wonder if anyone can help me ?
---------- Forwarded message ----------
From: Tompkins Neil <neil.tompkinsgooglemail.com>
Date: Tue, Oct 5, 2010 at 10:07 AM
Subject: Design advice
To: "[MySQL]" <mysqllists.mysql.com>
I have a number of tables of which I use to compute totals. For example I
table : players_master
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.