Discrepancy in Stats

m.mitch
m.mitch
Joined: 11 Feb 05
Posts: 187
Credit: 2,188,893
RAC: 0
Topic 190724

From my Team Stats, BONIC@Australia, for Einstein:

01) Mike Mitchell 29,201.59 674.02 Australia (Sorted by RAC)
24) Mike Mitchell 29,003.66 670.01 Australia (Sorted by Total Credit)

How come there is such a large discrepancy in the Total Credit?

[edit]Oh, I checked a couple of other team members and they had simmilar discrepancies.[/edit]

Paul D. Buck
Paul D. Buck
Joined: 17 Jan 05
Posts: 754
Credit: 5,385,205
RAC: 0

Discrepancy in Stats

looks the same to me at 29,229.92 ...

m.mitch
m.mitch
Joined: 11 Feb 05
Posts: 187
Credit: 2,188,893
RAC: 0

RE: looks the same to me at

Message 24897 in response to message 24896

Quote:
looks the same to me at 29,229.92 ...

How come when I posted, there was nearly 200 difference?

Pooh Bear 27
Pooh Bear 27
Joined: 20 Mar 05
Posts: 1,376
Credit: 20,312,671
RAC: 0

RE: How come when I posted,

Message 24898 in response to message 24897

Quote:
How come when I posted, there was nearly 200 difference?

My only guess is you saw it as the site was updating it's stats from the XML file. It sound like they might do things a little inefficient and have seperate tables for the sorts, which would cause this.

Also, your browser may have cached something, and would not let go. That happens every so often with most browsers.

Michael Karlinsky
Michael Karlinsky
Joined: 22 Jan 05
Posts: 888
Credit: 22,528,848
RAC: 5,650

RE: RE: looks the same to

Message 24899 in response to message 24897

Quote:
Quote:
looks the same to me at 29,229.92 ...

How come when I posted, there was nearly 200 difference?

These pages are not generated on-the-fly, but pregenerated at
distinct intervals, AFAIK.

Michael

m.mitch
m.mitch
Joined: 11 Feb 05
Posts: 187
Credit: 2,188,893
RAC: 0

I understand that the

I understand that the database needs updating but I would have the total would be one field.
If I get a list of Active team members by RAC, then it should display the same total on the credits when I click on total by Credit.
Updates are not an issue, the lower number came out last.
No cache problem, I had allowed for that - refreshed.
I'm terribly confused why there would be a different field for "total" in the RDBMS when sorted a different way. Sounds like the DB has not been normalised (and I'm no big fan of data normalisation).
Oh, not that anyone brought it up, I wasn't concerned by the discrepancy between the total shown on my "Account" page and the sorted totals, I had expected a delay between updates there.
It's all a bit strange 8-(

Keck_Komputers
Keck_Komputers
Joined: 18 Jan 05
Posts: 376
Credit: 5,744,455
RAC: 0

RE: I understand that the

Message 24901 in response to message 24900

Quote:

I understand that the database needs updating but I would have the total would be one field.
If I get a list of Active team members by RAC, then it should display the same total on the credits when I click on total by Credit.
Updates are not an issue, the lower number came out last.
No cache problem, I had allowed for that - refreshed.
I'm terribly confused why there would be a different field for "total" in the RDBMS when sorted a different way. Sounds like the DB has not been normalised (and I'm no big fan of data normalisation).
Oh, not that anyone brought it up, I wasn't concerned by the discrepancy between the total shown on my "Account" page and the sorted totals, I had expected a delay between updates there.
It's all a bit strange 8-(


The pages are cached on the server so any amount of refreshes from your browser may have no effect.

BOINC WIKI

BOINCing since 2002/12/8

F. Prefect
F. Prefect
Joined: 7 Nov 05
Posts: 135
Credit: 1,016,868
RAC: 0

Must be something going on or

Must be something going on or a lack thereof. For the first time since I signed up over a month ago, all of my machines are reporting exactly the same number 55653.72. I haven't seen an update since this AM. Oh well, at least it appears the data was uploaded.

F. Prefect

In the beginning the Universe was created. This has made a lot of people very angry and been widely regarded as a bad move.....Douglas Adams

DanNeely
DanNeely
Joined: 4 Sep 05
Posts: 1,358
Credit: 2,340,637,864
RAC: 3,307,145

the validator's been down for

the validator's been down for a while. Swagging from my pending credit, since this morning.

DanNeely
DanNeely
Joined: 4 Sep 05
Posts: 1,358
Credit: 2,340,637,864
RAC: 3,307,145

up again, and starting to

up again, and starting to chew through the backlog.

m.mitch
m.mitch
Joined: 11 Feb 05
Posts: 187
Credit: 2,188,893
RAC: 0

RE: The pages are cached on

Message 24905 in response to message 24901

Quote:
The pages are cached on the server so any amount of refreshes from your browser may have no effect.

I wouldn't have thought that would include the sorted pages. If that were the case, it would appear to be DB design flaw. Although that would explain the odd behaviour of the sort facility.

OT NOTE: I used MS Word to spell check this post. I have come to the conclusion that Bill Gates and all his employees are illiterate!
Although, it appears that the Thesaurus works well. This is the look-up list for illiterate: ignorant, unlettered, untaught, untutored, uneducated, and uninstructed. ;-)

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.