Results 1 to 18 of 18

Thread: Team Stats

  1. #1
    Target Butt IronBits's Avatar
    Join Date
    Dec 2001
    Location
    Morrisville, NC
    Posts
    8,619

    Team Stats

    teamname amount points
    PSP (no team specified) 55178 44301.155938
    Rechenkraft.net - Germany 27588 11453.061211
    Free-DC 12 1.177914

    IronBits 5 0.490514 Free-DC
    PCZ 4 0.392846 Free-DC
    MrTRS 3 0.294555 Free-DC

    So far... Looks like we have a LOT of catching up to do already

    http://www.boardpages.com/psp/viewtopic.php?p=1897 Official Forum for Team Free-DC

  2. #2
    There are 5000 points for anyone who finds a prime!

    15 primes left to be found!!!

    15*5000=750...

    Citrix

  3. #3
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,444
    Blog Entries
    13
    Ok, some questions on this...

    Looking at the stats page, I'm guessing I should only harvest the PRP stats, right ?

    Also, if you add together the two rows for Rechenkraft they don't tally with the team stats underneath??? I'll just ignore the teamstats and do my own summing anyway, but thought I'd point it out...

    Also, should the main metric be points or amount ? I think points.

    Bok

  4. #4
    Originally posted by Bok
    Ok, some questions on this...

    Looking at the stats page, I'm guessing I should only harvest the PRP stats, right ?

    Also, if you add together the two rows for Rechenkraft they don't tally with the team stats underneath??? I'll just ignore the teamstats and do my own summing anyway, but thought I'd point it out...

    Also, should the main metric be points or amount ? I think points.

    Bok

    Looking at the stats page, I'm guessing I should only harvest the PRP stats, right ?

    Yes, unless you take part in the sieve process, for whcih you are most welcomed to do so.






    Also, if you add together the two rows for Rechenkraft they don't tally with the team stats underneath??? I'll just ignore the teamstats and do my own summing anyway, but thought I'd point it out...

    They add up for me! Check it again!


    Also, should the main metric be points or amount ? I think points.

    I agree points and that is the way it is right now. SInce we have very few users the points and amount give the same order right now.

    Citrix


  5. #5
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,444
    Blog Entries
    13
    Originally posted by Citrix

    Also, if you add together the two rows for Rechenkraft they don't tally with the team stats underneath??? I'll just ignore the teamstats and do my own summing anyway, but thought I'd point it out...

    They add up for me! Check it again!
    Am I missing something ??

    ltd 28362 11544.127182 Rechenkraft.net - Germany

    Thommy3 500 29.120524 Rechenkraft.net - Germany

    Points total

    11544.127182 + 29.120524 = 11573.248

    Amount total

    28362 + 500 = 28862

    yet in the teamstats below is

    Rechenkraft.net - Germany 27588 11453.061211

    ??? ??? ??? ???

    Bok

  6. #6
    You are right!

    Sorry I din't look at it that closely.

    I will look into it as soon as I get time.

    Citrix

  7. #7
    @Bok
    The team stats had worked correctly for some time so i did stop to check it.
    There must be something i have destroied when playing around with my scripts.

    Strange enough the stats for Free-DC are correct at the moment ( 41 results counted )

    Lars
    www.Rechenkraft.net - most comprehensive german website about distributed computing projects

  8. #8
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,444
    Blog Entries
    13
    What are the scripts written in? Perl ? Bash?

    Database = mysql ?

    linux or windows ?

    Perhaps I can help....

    Bok

  9. #9
    Found the error.
    I had not counted some of my own results due to some changes.
    Corrected stats are online.

    The DB is at the moment on windows but i want to transfer it back to my linux server.
    Any help is welcome as this is the first time i work with MySQL and also with PHP.
    Its not that bad for a first time project but......

    As i know how to write most of the queries (years of oracle experience)
    i have only problems where the MySQL syntax is different. Special i fight with datetime comparisons

    But my biggest problem is the tuning of the server itself.
    Changed some parameters which should speed up things overall but what happend was that a query where i did only expect small gains was significant faster and the stats generation where i thought to gain was much slower.

    Lars
    www.Rechenkraft.net - most comprehensive german website about distributed computing projects

  10. #10
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,444
    Blog Entries
    13
    Originally posted by ltd
    Found the error.
    I had not counted some of my own results due to some changes.
    Corrected stats are online.

    I"ll run my stats.. Done..


    The DB is at the moment on windows but i want to transfer it back to my linux server.
    Any help is welcome as this is the first time i work with MySQL and also with PHP.
    Its not that bad for a first time project but......

    As i know how to write most of the queries (years of oracle experience)
    i have only problems where the MySQL syntax is different. Special i fight with datetime comparisons
    hehe, I've had that same battle with datetimes, I'm an Oracle DBA too In Mysql I sometimes find it easier to convert dates to the internal format for comparison, but I tend to keep away from datetime and just stick with date if I can help it.


    But my biggest problem is the tuning of the server itself.
    Changed some parameters which should speed up things overall but what happend was that a query where i did only expect small gains was significant faster and the stats generation where i thought to gain was much slower.

    Lars
    Almost certainly an index problem, but you already know that

    If you want to get me the schema I'd be happy to take a look, pm me here.

    Bok

  11. #11
    @Bok
    One question,

    do you know a good tool that shows some performance figures for a select put into the server. At least an execution plan.

    Lars
    www.Rechenkraft.net - most comprehensive german website about distributed computing projects

  12. #12
    Administrator Bok's Avatar
    Join Date
    Oct 2003
    Location
    Wake Forest, North Carolina, United States
    Posts
    24,444
    Blog Entries
    13
    I've never used any tools other than phpmyadmin. This could help though. It's very easy to install.

    Bok

  13. #13
    Stats Developer magnav0x's Avatar
    Join Date
    Mar 2002
    Location
    Dallas, TX
    Posts
    1,747
    I'd highly suggest trying out SQLyog for Windows. Great little SQL utility. Sure beats the hell out of trying to use phpmyadmin for anything useful.
    Warning this Post is Rated "M" for Mature

    -Contains Harsh Language
    -L337 HaX0r W3RD2!
    -Partial Nudity

    I haven't lost my mind; it's backed up on tape drive somewhere.

  14. #14
    Originally posted by Citrix
    There are 500 points for anyone who finds a prime!

    Reduced to 500 points now.

    Citrix

  15. #15
    Is any one form this team going to help us with the PRP effort. This team is in the third place right now (huge difference between team 2 and 3). I am waiting to see the real power of this team.

    http://www.mersenneforum.org/showthread.php?t=2665



    Citrix


  16. #16
    Free-DC's Prime Search
    Join Date
    Apr 2004
    Posts
    2,518
    I am Free-DC top member in both Sieve and PRP client. ---->>Check here.



    Carlos

  17. #17
    Target Butt IronBits's Avatar
    Join Date
    Dec 2001
    Location
    Morrisville, NC
    Posts
    8,619

  18. #18
    Free-DC's Prime Search
    Join Date
    Apr 2004
    Posts
    2,518
    Now that PSP stats were added to Bok's stats page I would like to see more people running PSP. Soon it will be added to DCR style Stats so it's a good way to go up in the ranking.

    Carlos

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •