| # |
Aug 8th 2008, 08:53 |
TommyO |
now your bottleneck went awat again |
| # |
Aug 8th 2008, 08:53 |
TommyO |
well that's easier still, since the scores are no-longer changing on the fly. have the process that 'closes' the quiz calculate the scores |
| # |
Aug 8th 2008, 08:52 |
ammadsaleem1 |
now what |
| # |
Aug 8th 2008, 08:52 |
ammadsaleem1 |
u cannot see the score card untill All questions have correct answers specified or till the Result announcement date has arrived |
| # |
Aug 8th 2008, 08:51 |
ammadsaleem1 |
but there is another catch |
| # |
Aug 8th 2008, 08:51 |
TommyO |
get the answers. get the correct answer. calc the scores. cache if possible. display |
| # |
Aug 8th 2008, 08:51 |
ammadsaleem1 |
okay so each user must see his scorecard in oder for the leaderboard to be updated |
| # |
Aug 8th 2008, 08:50 |
ammadsaleem1 |
can you also see a solution |
| # |
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 |