| # |
Aug 8th 2008, 08:50 |
TommyO |
ammadsaleem1: I would have the score calculated on scoreboard view and not stored anywhere I think |
| # |
Aug 8th 2008, 08:50 |
TommyO |
ok. now I see the load problem :) |
| # |
Aug 8th 2008, 08:50 |
ammadsaleem1 |
yup |
| # |
Aug 8th 2008, 08:50 |
TommyO |
based on the quiz's whim |
| # |
Aug 8th 2008, 08:49 |
TommyO |
or up |
| # |
Aug 8th 2008, 08:49 |
TommyO |
ammadsaleem1: so the score isn't based on what the answer was when they answered it, but what it is after a change. meaning a player's score could go down? |
| # |
Aug 8th 2008, 08:49 |
tbranyen_ |
i'm having trouble understanding where your bottleneck is |
| # |
Aug 8th 2008, 08:49 |
ammadsaleem1 |
now what can be done |
| # |
Aug 8th 2008, 08:49 |
ammadsaleem1 |
questons |
| # |
Aug 8th 2008, 08:48 |
ammadsaleem1 |
yupthats real world quizzes |
| # |
Aug 8th 2008, 08:48 |
tbranyen_ |
haha yeah |
| # |
Aug 8th 2008, 08:48 |
TommyO |
'change the correct answer' wow, that's a weird quiz. |
| # |
Aug 8th 2008, 08:48 |
ammadsaleem1 |
so ... |
| # |
Aug 8th 2008, 08:48 |
ammadsaleem1 |
and finally the total score for the Quiz for the user is calculated |
| # |
Aug 8th 2008, 08:47 |
ammadsaleem1 |
the Quiz maker can change the anser any time |
| # |
Aug 8th 2008, 08:47 |
ammadsaleem1 |
for each anser we need to calculate fast response bonus, partial score and total score |
| # |
Aug 8th 2008, 08:47 |
TommyO |
ammadsaleem1: I would do it on answer save if you want real-time |
| # |
Aug 8th 2008, 08:46 |
ammadsaleem1 |
and then from the scorecard a leader board is being generated |
| # |
Aug 8th 2008, 08:46 |
tbranyen_ |
still thats pretty simplistic for any database engine |
| # |
Aug 8th 2008, 08:46 |
ammadsaleem1 |
each has it in its scorecard |
| # |
Aug 8th 2008, 08:46 |
ammadsaleem1 |
2000 players have attempted a question in a quiz |
| # |
Aug 8th 2008, 08:46 |
tbranyen_ |
over 10k records i would consider massive |
| # |
Aug 8th 2008, 08:45 |
tbranyen_ |
that doesn't seem very massive |
| # |
Aug 8th 2008, 08:45 |
ammadsaleem1 |
we have shared hosting plus we want the results to be real time |
| # |
Aug 8th 2008, 08:45 |
ammadsaleem1 |
the Quiz maker updates the answer of the question, then all the player who have attempted the question, their scores get recalculated |
| # |
Aug 8th 2008, 08:44 |
pgcd_away |
tommy0: thanks |
| # |
Aug 8th 2008, 08:44 |
TommyO |
or scheduler |
| # |
Aug 8th 2008, 08:44 |
TommyO |
ammadsaleem1: sounds like the work of a cron job |
| # |
Aug 8th 2008, 08:44 |
tbranyen_ |
Because the former is a horrible idea and the latter can be done by just adding a script to the rc local or windows startup |
| # |
Aug 8th 2008, 08:43 |
tbranyen_ |
whenever someone hits the site or whenever the server starts? |
| # |
Aug 8th 2008, 08:43 |
tbranyen_ |
ammadsaleem1 a mass database update when? |
| # |
Aug 8th 2008, 08:43 |
ammadsaleem1 |
? |
| # |
Aug 8th 2008, 08:43 |
ammadsaleem1 |
can cake help me in this regard |
| # |
Aug 8th 2008, 08:43 |
TommyO |
pgcd_away: $this->model() |
| # |
Aug 8th 2008, 08:43 |
TommyO |
pgcd_away: see Helper class, which all helpers, including your, inherits. it has a model() method |
| # |
Aug 8th 2008, 08:42 |
ammadsaleem1 |
? |
| # |
Aug 8th 2008, 08:42 |
ammadsaleem1 |
is there any other solution to the probelm |
| # |
Aug 8th 2008, 08:41 |
ammadsaleem1 |
since it may cause script time out, so i am going for threading |
| # |
Aug 8th 2008, 08:41 |
ammadsaleem1 |
The thing I want to carry out is to perform a mass database update |
| # |
Aug 8th 2008, 08:39 |
pgcd_away |
of course, i might resort to good old foreach, if needed |
| # |
Aug 8th 2008, 08:39 |
TommyO |
it is stateless |