What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 128 Stack Exchange communities.

I have take a look at Jon Skeet's info page, and found that his current reputation is 538k. And now I have a question, what is the maximum reputation for a user? Is it 1000k or unlimited?

share|improve this question

marked as duplicate by hims056, Andrew Barber, Toon Krijthe, Diago, ChrisF Mar 1 '13 at 11:16

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

5  
Depends on what the datatype they use is. –  Mysticial Mar 1 '13 at 9:40
13  
It's an ever increasing maximum as defined by Jon Skeet. Simple as that. –  Bart Mar 1 '13 at 9:43
3  
I suspect 2147483647. –  John Willemse Mar 1 '13 at 9:46
3  
August 28, 2016 we'll know whether there is a 1000k limit. –  Gert Arnold Mar 1 '13 at 9:46

3 Answers 3

up vote 14 down vote accepted

This depends entirely on the datatype used for the total reputation column in the database. The Stack Exchange software stack is based on Microsoft SQL Server 2012 (although it started out on MS SQL Server 2008).

MS SQL Server has several integer types; if the column is of type int, then the limit is 2,147,483,647 (2 billion plus change). And the Stack Exchange Data Explorer filtered copy of the site data uses int for reputation, making it very likely that the production database uses the same type.

Edit: Nick Craver confirmed int is used. That means we have another 2000 years to go before Jon Skeet's reputation forces a database upgrade to bigint.

share|improve this answer
    
It would be more effective to use the unsigned version, as there cannot be a negative reputation. So 4 billion plus change it is :) –  Second Rikudo Mar 1 '13 at 9:49
    
@MadaraUchiha: I don't see an unsigned version of the int type. –  Martijn Pieters Mar 1 '13 at 9:50
    
A database without an unsigned version of a number column? Yeah, I see why I don't use it :P –  Second Rikudo Mar 1 '13 at 9:53
    
According to data.stackexchange.com, Reputation is an int. So this is correct. –  ThinkingStiff Mar 1 '13 at 9:56
    
@ThinkingStiff: Since the SEDE is a filtered copy of the database, we cannot be 100% certain that the production database uses the same type, but it certainly would make sense if it did. :-) –  Martijn Pieters Mar 1 '13 at 9:57
3  
This is correct –  Nick Craver Mar 1 '13 at 11:08

There are several types of numbers in a database (all unsigned, because there can't be a negative reputation):

  • TINYINT - 0-255. Obviously not.
  • SMALLINT - 0-65535. Obviously not.
  • MEDIUMINT - 0-16777215. Possible, though I don't know.
  • INT - 0-4294967295. Possible, that's probably it.
  • BIGINT - 0-18446744073709551615. Overkill, but who knows, based on Jon Skeet that may be the case.

I don't know exactly which Stack Exchange uses, but if anything, it's MEDIUMINT and above.

share|improve this answer

Jon Skeet has an average of 333.90... points per day.

538 283 (JonSkeetRep) / 53 (MonthsActive) * (365 / 12) (avgDaysPerMonth)

2^32 = 4294967296 (unsigned int)

4294967296 / 333.90 (JonSkeetDailyRepAvg) = 12863034.7289... (NumberOfDaysToOverflow)

12863034.7289 (NumberOfDaysToOverflow) / 365.25 (AvgDaysInYear) = 35217.069757... (NumberOfYearsToOverflow)

So Jon Skeet would still have to live another 35217 years.

share|improve this answer
3  
I think my average rep per day is now more like 338 than 280. –  Jon Skeet Mar 1 '13 at 10:59
    
The reputation cap still works on Jon Skeet. He cannot earn more than 200 rep/day, and his reputation cannot expand past that daily (he still gets votes/accepts though, but still a 200 rep limit is a 200 rep limit) –  Grammar Apr 9 '13 at 16:26
1  
@Grammar: the reputation cap doesn't apply to accepts. –  Martijn Pieters Jul 15 at 18:38
1  
@Grammar: It also doesn't apply to bounties. –  Reto Koradi Jul 15 at 20:24

Not the answer you're looking for? Browse other questions tagged .