Re: Where store calculated values from several tables?

2006-07-17T18:39:06-07:00

My rule of thumbÃƒÆ’Ã‚ ¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦
If you are going to store data to be retrieved only once and not use in some other process try the calculation method firstÃƒÆ’Ã‚ ¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ it should be faster than an sql queryÃƒÆ’Ã‚ ¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦

The calculation should be done in the in the php file that send data to the associated tpl fileÃƒÆ’Ã‚ ¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦

If you are doing several calculations (one for each game) then you should consider saving these to the databaseÃƒÆ’Ã‚ ¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦

Mike

Statistics: Posted Author: Michaelo — Mon Jul 17, 2006 6:39 pm

Where store calculated values from several tables?

2006-07-11T07:17:07-07:00

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

Statistics: Posted Author: Rixn — Tue Jul 11, 2006 7:17 am

IntegraMOD

Re: Where store calculated values from several tables?

Where store calculated values from several tables?