Author |
Message |
tom ![](fl/us)
Posted on: Fri Mar 02, 2012 1:04 pm
Posts: 17 Joined: Fri May 13, 2011 2:12 am
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Confused about weekly stats
Patrick, I was confused as to how mparisi total points for the 7 day went from 25 points approx less than mine to 35 points approx more than my total in one day?? The stats in question are for 3 march. I thought i saw a similar thing last week.
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
pnm ![](fl/ua)
Posted on: Fri Mar 02, 2012 6:21 pm
Posts: 3305 Joined: Thu May 12, 2011 11:58 pm
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
tom wrote: Patrick, I was confused as to how mparisi total points for the 7 day went from 25 points approx less than mine to 35 points approx more than my total in one day?? The stats in question are for 3 march. I thought i saw a similar thing last week. When exactly did you see this? Right after midnight? (I'm asking because the daily updating of the 7 day scores runs as a "slow process", so not all totals are updated at the same time)(it takes about 20 minutes in total)
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
tom ![](fl/us)
Posted on: Fri Mar 02, 2012 6:38 pm
Posts: 17 Joined: Fri May 13, 2011 2:12 am
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
Patrick i looked 10 am est. For the past week I have been ahead on points & I am completing all puzzles, 3 points for timed & 5 points a day for book puzzles. This morning I looked at stats & noticed.
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
pnm ![](fl/ua)
Posted on: Fri Mar 02, 2012 6:53 pm
Posts: 3305 Joined: Thu May 12, 2011 11:58 pm
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
tom wrote: Patrick i looked 10 am est. For the past week I have been ahead on points & I am completing all puzzles, 3 points for timed & 5 points a day for book puzzles. This morning I looked at stats & noticed. It was indeed an error, and looks like a bug :-( mparisi's total has been updated now, I'll try to find out if there's an error somewhere.. Thanks for letting me know, Patrick
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
pnm ![](fl/ua)
Posted on: Fri Mar 02, 2012 6:57 pm
Posts: 3305 Joined: Thu May 12, 2011 11:58 pm
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
I think it may have been a "race condition" (!) (term from concurrent programming): mparisi solved a puzzle, then: 1) current total is retrieved from the db 2) the "recompute weekly points" process updates the total in the db 3) new total is computed, and db is updated (!) I've put in a fix by doing (I hope..) proper database table locking whenever a new solution is entered. So in an ideal world this'll never happen again ![Laugh :-)](./images/smilies/msp_laugh.gif) Patrick
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
sneaklyfox ![](fl/ca)
Posted on: Mon Mar 05, 2012 3:49 am
Posts: 428 Location: Canada Joined: Fri May 13, 2011 2:43 am
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
Hmm... how about tom on 7-day ranking... another bug or similar problem? I don't even know where he was yesterday but today he's like 50 points more than me. Maybe whatever was changed didn't exactly fix everything.
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
tom ![](fl/us)
Posted on: Mon Mar 05, 2012 4:52 am
Posts: 17 Joined: Fri May 13, 2011 2:12 am
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
sneaklyfox, I agree. My 7 day stat is not correct.
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
pnm ![](fl/ua)
Posted on: Mon Mar 05, 2012 10:39 am
Posts: 3305 Joined: Thu May 12, 2011 11:58 pm
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
tom wrote: sneaklyfox, I agree. My 7 day stat is not correct. Hm, I thought I had fixed the problem :-( I corrected the total, and will check again...
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
clm ![](fl/ua)
Posted on: Mon Mar 05, 2012 1:43 pm
Posts: 857 Joined: Fri May 13, 2011 6:51 pm
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
pnm wrote: tom wrote: sneaklyfox, I agree. My 7 day stat is not correct. Hm, I thought I had fixed the problem :-( I corrected the total, and will check again... I think I have observed occasionally those "blunder points" only in the 7-day punctuation that dissappear after 24 hours; it looks related, on thursdays and sundays, to the special (72 hours time for the solution) 12x12's; it might be related to the exact instant you solve it with respect to the instant you had solved the equivalent 12x12 7 days ago, that is, for instance, if you solve the 12x12 at 03:00 on a thrusday 8 and the next 12x12 on thursday 15 is solved at 02:00 (before completing the 168 hours period for the 7-day). Though one could think that it would only affect to 16 points and not to the whole punctuation of one day, but the jump is really high and can not be explained with the 12 points of a book solution (I may have a wrong impression though I would revise the routine for the 12x12's). No problems with the golden star with the 12x12 (you must solve it within the day is published to get the star that day, right?).
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
sneaklyfox ![](fl/ca)
Posted on: Tue Apr 10, 2012 4:39 am
Posts: 428 Location: Canada Joined: Fri May 13, 2011 2:43 am
|
![Post Post](./styles/etech/imageset/icon_topic_latest.gif) Re: Confused about weekly stats
Still not sure how this thing works as rickt has like 650ish points. Shouldn't it be updated when the "day" changes? And if it's a slow process, it should be all updated within the first half hour of the day changing. This happened a few days ago too.
|
|
|
![](./styles/etech/theme/images/spacer.gif) |
|