Wonder if anyone can help me ? ---------- Forwarded message ---------- From: Tompkins Neil <neil.tompk...@googlemail.com> Date: Tue, Oct 5, 2010 at 10:07 AM Subject: Design advice To: "[MySQL]" <mysql@lists.mysql.com>
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