Official Donor Stats Change

[DocJonz]

Something has changed on the official donor stats page in the last day or so;
If you click on your own donor stats, then under your user name, it outputs; "Rank X of Y".
Y, until the day before yesterday, was increasing over the years and had reached 3,012,069. Yesterday (and today) it is 1,000,000.
A glitch, or a reset perhaps?

[muziqaz]

Hi,
You mean Rank xxx out of 1000000?
It seems that stats database has been trimmed and most likely inactive people were hidden.
I'll ask around
Thanks

[DocJonz]

Yes, in my case it was actually "Rank 28 of 3,012,069", now it is "Rank 27 of 1,000,000" (... 27 as I moved up one place in the meantime )

One million seems a very round number ... and it hasn't changed in 2 days - that is not normal behaviour for this parameter.

[muziqaz]

Yes, in my case it was actually "Rank 28 of 3,012,069", now it is "Rank 27 of 1,000,000" (... 27 as I moved up one place in the meantime )

One million seems a very round number ... and it hasn't changed in 2 days - that is not normal behaviour for this parameter.

Still waiting for the response to that

[PaulTV]

Yes, in my case it was actually "Rank 28 of 3,012,069", now it is "Rank 27 of 1,000,000" (... 27 as I moved up one place in the meantime )

It'd be more interesting if you'd now be 1,744,028 of 1,000,000 But grats on the move to 27

[appepi]

My theory of the case is that this 1,000,000 business is a placeholder while the database is rejigged for 8.4.x web control. simply because it would be a million-to one chance that there were exactly 1 million active users and that the 30-300 new users each day stopped joining at that point. But just in case it is a prelude to trim the database, I want to lodge the following objection:

I note that in the All Users list at Extreme Overclocking at the last page (7251) you find user rank #1,303,519, with a score of 5,001 points. Page 5892 spans 100 or so users around rank #1,000,000 all with about 18000 points. None of the folk in that area seem to be active, but should "inactive" users be excluded? As an example, quite a few of the teams ahead of me aren't "active" - these being the main reason I can climb the ladder at all - but should their historical contribution be ignored? What if an active user takes a break, gets trimmed, and returns? Surely the same Fah that doles out gazillions of atoms to juggle each day can maintain a database of 3 million donors, past and present? And so on and so forth.

[muziqaz]

"The query to count the number of users was running on every stats query and putting a large load on the DB. I temporarly replaced it with 1,000,000." - fah dev

[DocJonz]

Would a simple fix not be to count it independently once (maybe hourly?) and then pass/parse the value to any user query during that time period (?)

[muziqaz]

Nothing is simple

[DocJonz]

True

If the number is just going to be arbitrarily invented, might as well remove it, since it has no useful meaning.

[The_Celt]

muziqaz, there are ways to do a very fast row count on a database table. It may be off by a very small count, but way better than a fixed 1,000,000. A simple google search yields the following query for MS SQL systems.

SELECT SUM(p.rows) FROM sys.partitions AS p
INNER JOIN sys.tables AS t
ON p.[object_id] = t.[object_id]
INNER JOIN sys.schemas AS s
ON s.[schema_id] = t.[schema_id]
WHERE t.name = N'YourTableNameHere'
AND s.name = N'dbo'
AND p.index_id IN (0,1);

[muziqaz]

If you guys want, you can raise a ticket in FAH Web client github, pretending that stats somehow are not showing all the users through V8 Stats section, and mention your suggestion on the database. The reason I'm using word "pretending" is because technically Stats are not fahclient issue, but there is no other way for you guys to get in contact with the dev. Dev reads GitHub, and he has been notified about the stat issue, so he will know what you are talking about. The reason I'm not doing this myself is because you would forgo me as a middle man, and could have a straight up conversation about resolving it, instead of me relaying each of you messages to each other Of that makes sense

[muziqaz]

P.S. don't mention that I suggested posting at GitHub, I'll get killed for that