It is a limitation on the variable type that holds this information for each member.
It was in fact changed once before - about a year and a half ago, I think. The original field size for that variable was 2^31 (or, 2,147,483, 648); it was changed after a number of people maxed out to 2^63, the current value (or, 9,223,372,036,854,780,000).
The problem with reputation is that it is an exponential function - in other words, it increases exponentially, not linearly. Whereas it took a number of years for people to reach the first limit, it took but a few months for them to max out at the next limit (which is over 4 billion times as large as the first limit).
The next limit would be 2^127 (or, 170,141,183,460,469,000,000,000,000,000,000,000,000). I doubt we'll go there due to the massive memory necessary to contain such information for so many people.
Honestly, a total revamping of the reputation system needs to occur to enable the system to work properly - which I doubt will take place either.
We're actually looking at it. The process is as you say above...
Exactly. Trim top users down to the first three digits of reputation, reload everyone below a certain level to a base value, reset some powers and drop the rep repeat rates.
That is one way but it is sort of a pain...not only that but I'm not entirely sure that I want to be in the position of deciding who gets what. That being said...it is more than merely running a few SQL queries (which would nuke things right quick). We'd have to take the board down, run a backup, run the queries, rebuild all user reps, ensure that everything worked right, and then turn the board back on (assuming that everything didn't geek up...in which case we'd need to reload the backup).
So...given the size of our DB etc...I simply dunno about this. Granted, I personally think that the situation is a bit silly / gotten out of hand. I get a little queasy when I think of entire tables being emptied (for a variety of reasons).
So...sort of "who knows" / no real answer at the moment, I guess.
Upvote
0