I've got a DB with highscores from several Shockwave games. Each game has its own table with the columns Score, Name and Date. In addition I've got a table with game parameters like game name, type, score type and so on.
Now I want to keep track on statistics for the games, that is values that I get from each game that I do some calculation on. Should I store those in the additional table or should I calculate them each time I need them?
Is it possible to have a script running in the back to calculate these values and then keep storing them into the table? I fear that always calculating when I need the values would slow things down so I hope one can solve this in another way.
What do you all say about this - what should I do?
Regards
/Rixn