Team Stats

[IronBits]

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 :Pokes:

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

[Citrix]

There are 5000 points for anyone who finds a prime!:)

15 primes left to be found!!!

15*5000=750...

Citrix
:cool: :cool: :cool:

[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 :cheers:

[Citrix]

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 :cheers:

:)
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

:cool: :cool: :cool:

[Bok]

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

[Citrix]

You are right!

Sorry I din't look at it that closely.:bang:

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

Citrix
:cool: :cool: :cool:

[ltd]

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

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

Lars

[Bok]

What are the scripts written in? Perl ? Bash?

Database = mysql ?

linux or windows ?

Perhaps I can help....

Bok :D

[ltd]

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 :swear:

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

[Bok]

Originally posted by ltd
Found the error.
I had not counted some of my own results due to some changes.
Corrected stats are online.




:|party|: 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 :swear:


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

:spank: Almost certainly an index problem, but you already know that :p

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

Bok :D

[ltd]

@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

[Bok]

I've never used any tools other than phpmyadmin. This could help though. It's very easy to install.

Bok

[magnav0x]

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.

[Citrix]

Originally posted by Citrix
There are 500 points for anyone who finds a prime!:)



Reduced to 500 points now.

Citrix
:cool: :cool: :cool:

[Citrix]

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

:cool: :cool: :cool:

[em99010pepe]

I am Free-DC top member in both Sieve and PRP client. ---->>Check here (http://www.ldausch.de/stats.html).

:elephant: :elephant: :elephant:

Carlos

[IronBits]

:|party|: :cheers: :thumbs:

[em99010pepe]

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