Leaderboard Stats

Message boards : Number crunching : Leaderboard Stats

Author	Message
Atomic Booty Volunteer tester Joined: Sep 13 06 Posts: 59 ID: 23 Credit: 30,370 RAC: 0	Message 270 - Posted 16 Sep 2006 17:00:04 UTC Last modified: 16 Sep 2006 17:04:39 UTC
	How often are the team/participant stats updated? And why are there inconsistencies in the displayed results? Different scores are shown depending on how you have them categorized (by RAC or TC). Also, when I click on my team's name (Knights Who Say Ni!), the members - all 2 of us - are not visible until I click on our TC first. I looked at some other team pages for comparison, and did not see the problem there, maybe we are just really stealthy! Minor stuff I know, but just wondering. Thanks, Atomic
	ID: 270 \| Rating: 0 \| rate: /

Atomic Booty Volunteer tester Joined: Sep 13 06 Posts: 59 ID: 23 Credit: 30,370 RAC: 0	Message 271 - Posted 16 Sep 2006 17:05:37 UTC
	hmmm, ok we are showing up now... either you fixed it really fast or it's toying with me!
	ID: 271 \| Rating: 0 \| rate: /

j2satx Volunteer tester Joined: Dec 22 06 Posts: 183 ID: 339 Credit: 16,191,581 RAC: 0	Message 2402 - Posted 5 Feb 2007 20:01:55 UTC - in response to Message ID 270 .
	How often are the team/participant stats updated? And why are there inconsistencies in the displayed results? Different scores are shown depending on how you have them categorized (by RAC or TC). Also, when I click on my team's name (Knights Who Say Ni!), the members - all 2 of us - are not visible until I click on our TC first. I looked at some other team pages for comparison, and did not see the problem there, maybe we are just really stealthy! Minor stuff I know, but just wondering. Thanks, Atomic @AK, scores still different by a small amount. Doesn't seem like both tables get updated or indexed at the same time.
	ID: 2402 \| Rating: 0 \| rate: /

Andre Kerstens Forum moderator Project tester Volunteer tester Joined: Sep 11 06 Posts: 749 ID: 1 Credit: 15,199 RAC: 0	Message 2403 - Posted 5 Feb 2007 20:57:05 UTC - in response to Message ID 2402 .
	This has to do with the fact that BOINC implements a cache for data generated for the web (incl. stats). This cache exists to make the load on the server less high and make it manageable. If you want to know more about it, you can find it here: http://boinc.berkeley.edu/web_cache.php Thanks Andre How often are the team/participant stats updated? And why are there inconsistencies in the displayed results? Different scores are shown depending on how you have them categorized (by RAC or TC). Also, when I click on my team's name (Knights Who Say Ni!), the members - all 2 of us - are not visible until I click on our TC first. I looked at some other team pages for comparison, and did not see the problem there, maybe we are just really stealthy! Minor stuff I know, but just wondering. Thanks, Atomic @AK, scores still different by a small amount. Doesn't seem like both tables get updated or indexed at the same time. ____________ D@H the greatest project in the world... a while from now!
	ID: 2403 \| Rating: 0 \| rate: /

j2satx Volunteer tester Joined: Dec 22 06 Posts: 183 ID: 339 Credit: 16,191,581 RAC: 0	Message 2405 - Posted 5 Feb 2007 22:44:12 UTC - in response to Message ID 2403 .
	This has to do with the fact that BOINC implements a cache for data generated for the web (incl. stats). This cache exists to make the load on the server less high and make it manageable. If you want to know more about it, you can find it here: http://boinc.berkeley.edu/web_cache.php Thanks Andre How often are the team/participant stats updated? And why are there inconsistencies in the displayed results? Different scores are shown depending on how you have them categorized (by RAC or TC). Also, when I click on my team's name (Knights Who Say Ni!), the members - all 2 of us - are not visible until I click on our TC first. I looked at some other team pages for comparison, and did not see the problem there, maybe we are just really stealthy! Minor stuff I know, but just wondering. Thanks, Atomic @AK, scores still different by a small amount. Doesn't seem like both tables get updated or indexed at the same time. Makes sense, thanks.
	ID: 2405 \| Rating: 0 \| rate: /

Message boards : Number crunching : Leaderboard Stats

Database Error
: The MySQL server is running with the --read-only option so it cannot execute this statement

array(3) {
  [0]=>
  array(7) {
    ["file"]=>
    string(47) "/boinc/projects/docking/html_v2/inc/db_conn.inc"
    ["line"]=>
    int(97)
    ["function"]=>
    string(8) "do_query"
    ["class"]=>
    string(6) "DbConn"
    ["object"]=>
    object(DbConn)#10 (2) {
      ["db_conn"]=>
      resource(66) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(50) "update DBNAME.thread set views=views+1 where id=39"
    }
  }
  [1]=>
  array(7) {
    ["file"]=>
    string(48) "/boinc/projects/docking/html_v2/inc/forum_db.inc"
    ["line"]=>
    int(60)
    ["function"]=>
    string(6) "update"
    ["class"]=>
    string(6) "DbConn"
    ["object"]=>
    object(DbConn)#10 (2) {
      ["db_conn"]=>
      resource(66) of type (mysql link persistent)
      ["db_name"]=>
      string(7) "docking"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(3) {
      [0]=>
      object(BoincThread)#3 (16) {
        ["id"]=>
        string(2) "39"
        ["forum"]=>
        string(1) "2"
        ["owner"]=>
        string(2) "23"
        ["status"]=>
        string(1) "0"
        ["title"]=>
        string(17) "Leaderboard Stats"
        ["timestamp"]=>
        string(10) "1170715452"
        ["views"]=>
        string(4) "1051"
        ["replies"]=>
        string(1) "4"
        ["activity"]=>
        string(20) "6.5022066861043e-125"
        ["sufferers"]=>
        string(1) "0"
        ["score"]=>
        string(1) "0"
        ["votes"]=>
        string(1) "0"
        ["create_time"]=>
        string(10) "1158426004"
        ["hidden"]=>
        string(1) "0"
        ["sticky"]=>
        string(1) "0"
        ["locked"]=>
        string(1) "0"
      }
      [1]=>
      &string(6) "thread"
      [2]=>
      &string(13) "views=views+1"
    }
  }
  [2]=>
  array(7) {
    ["file"]=>
    string(63) "/boinc/projects/docking/html_v2/user/community/forum/thread.php"
    ["line"]=>
    int(184)
    ["function"]=>
    string(6) "update"
    ["class"]=>
    string(11) "BoincThread"
    ["object"]=>
    object(BoincThread)#3 (16) {
      ["id"]=>
      string(2) "39"
      ["forum"]=>
      string(1) "2"
      ["owner"]=>
      string(2) "23"
      ["status"]=>
      string(1) "0"
      ["title"]=>
      string(17) "Leaderboard Stats"
      ["timestamp"]=>
      string(10) "1170715452"
      ["views"]=>
      string(4) "1051"
      ["replies"]=>
      string(1) "4"
      ["activity"]=>
      string(20) "6.5022066861043e-125"
      ["sufferers"]=>
      string(1) "0"
      ["score"]=>
      string(1) "0"
      ["votes"]=>
      string(1) "0"
      ["create_time"]=>
      string(10) "1158426004"
      ["hidden"]=>
      string(1) "0"
      ["sticky"]=>
      string(1) "0"
      ["locked"]=>
      string(1) "0"
    }
    ["type"]=>
    string(2) "->"
    ["args"]=>
    array(1) {
      [0]=>
      &string(13) "views=views+1"
    }
  }
}

query: update docking.thread set views=views+1 where id=39