JavaScript is required to use Bungie.net

#Septagon

11/22/2012 2:54:42 PM
43

Why is the max amount of accounts the eighth Mersenne prime?

What is so special about this [url=http://www.bungie.net/Account/Profile.aspx?memberID=2147483647]specific number[/url]? Why not 2147483648 maximum accounts? EDIT: Apparently [url=http://en.wikipedia.org/wiki/2147483647#2147483647_in_computing]this is why[/url]. Also, it would take approximately 1956 years and 202 days at the current rate to reach the current maximum accounts. The limit will be reached at 3967 with the current rate of new accounts. [b]Extra info[/b] The daily average accounts made has dropped (become more accurate) to 596.7875 users per day. [Edited on 11.22.2012 7:05 AM PST]

Posting in language:

 

Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

View Entire Topic
  • [quote][b]Posted by:[/b] funkbrotha10 Int32[/quote].NET defines that, but SQL Server does not. It is only int. Although that raises another interesting point. The reason you might end up on a dedicated error page after specifically requesting it through your browser is probably because each profile is defined as having an System.Int32 as the memberID [i]in the application logic[/i] (ASP.NET codebehinds/DLLs). So (if and when) validation being preformed in there on the memberID after being pulled from the GET line is unsuccessful in parsing it to a .NET Int32, it would be more efficient to fail early then and there without touching the database. [quote][b]Posted by:[/b] defnop552 So what happens when it reaches that number? Do new members get deleted account numbers?[/quote]After someone tried to sign up, they would likely end up on one of the dedicated error pages like the one Iggy linked, or the Database Exception one. Accounts wouldn't be deleted or overwritten since when the field set to increment (IDENTITY) reaches its max value (2^31 - 1 in this case) + 1, the INSERT statement would throw an exception back to client application (which is how you'd end up on an error page). This is more likely if the INSERT takes place within a transaction as well. [url=http://ideone.com/mpS9U7]It's not like C++ where bits rollover[/url], which is going to be a problem in the [url=http://en.wikipedia.org/wiki/Year_2038_problem]year 2038[/url]. Interestingly, [url=http://techcrunch.com/2009/06/12/all-hell-may-break-loose-on-twitter-in-2-hours/]Twitter also faced this problem a few years ago[/url] too.

    Posting in language:

     

    Play nice. Take a minute to review our Code of Conduct before submitting your post. Cancel Edit Create Fireteam Post

You are not allowed to view this content.
;
preload icon
preload icon
preload icon