Bungie.net Community
This topic has moved here: Subject: Why is the max amount of accounts the eighth Mersenne prime?
  • Subject: Why is the max amount of accounts the eighth Mersenne prime?
  • Pages:
  • 1
  • 2
  • of 2
Subject: Why is the max amount of accounts the eighth Mersenne prime?
  • gamertag: [none]
  • user homepage:

What is so special about this specific number?
Why not 2147483648 maximum accounts?
EDIT: Apparently this is why.

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.

Extra info
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]

  • 11.22.2012 6:54 AM PDT

I'm confused. Are you asking a question or not? It looks like you answered it yourself.

  • 11.22.2012 7:01 AM PDT

Posted by: AngryBrute1
Oh yeah, since somebody does not believe what YOU believe; that makes us vapid...
I cannot grasp that what you call "Something happened to nothing, and that nothing became something, and it was smaller than than a period."

Posted by: Mythical Wolf
I'm confused. Are you asking a question or not? It looks like you answered it yourself.


OT: The math part is really cool though.

  • 11.22.2012 7:13 AM PDT

Whisper Game Studios - shhhh, it's a public secret.
Webcam MVP
Sarsion.net
Bnet PM Policy

[*Please note that anything in my posts is likely to be filled with sarcasm, and should be taken with a pinch of salt. I tend to help people, usually*]

My brain died.

That's more numbers than peoples.

  • 11.22.2012 8:41 AM PDT

"Now, we must all fear evil men. But there is another kind of evil which we must fear most, and that is the indifference of good men."

Get at me

Wait, Bnet is getting 600 new accounts per day? That doesn't sound right...

  • 11.22.2012 11:08 AM PDT

Per Audacia Ad Astra

Posted by: lVl e r c u r y
Wait, Bnet is getting 600 new accounts per day? That doesn't sound right...
You'd be surprised. That's an average made from recordings since last October.

Roughly 376 accounts have been made in the last 24 hours.

  • 11.22.2012 11:11 AM PDT

*´¨)---––•(-• Dutchy •-)•–--–-(¨´*
¸.•´¸.•*´¨) ¸.•*¨)••(¨*•.¸ (¨´*•.¸´•.¸
(¸.•´ (¸.•Everything fails•.¸) ´•.¸)


Posted by: Bungie Sam
Posted by: lVl e r c u r y
Wait, Bnet is getting 600 new accounts per day? That doesn't sound right...
You'd be surprised. That's an average made from recordings since last October.

Roughly 376 accounts have been made in the last 24 hours.
I want everyone who makes these accounts to say hi to us on the forums.

IS THAT TOO MUCH TO ASK

  • 11.22.2012 11:29 AM PDT

That is a very fascinating discovery.

  • 11.22.2012 11:32 AM PDT

Кланяються мені!

The dedication of trolls is an inconceivable process. There are too many bad trolls today. They new accounts to simply be annoying and so they can attempt to avoid a ban.

  • 11.22.2012 12:07 PM PDT

That's interesting.

  • 11.22.2012 1:02 PM PDT

Why not stop by my File Share while you're here?

~Long Live Halo 2
Only regret is I didn't play more of it.

If you haven't noticed by now, I'm sort of a jerk.

Holy -blam!-. I swear, if one more person says everyone of the new accounts is a troll account, I'll never be able to take a single post of theirs seriously again. Do you have any idea how stupid it sounds to say every new account that joins is a trolling account? You sound so ignorant when you just write things off like that, what if you were just written off as a troll when you first joined? Would you continue to visit the site? Just because there isn't much happening right now doesn't mean that every new account that joins is a trolling or alternate account.
Posted by: ecartman1214
The dedication of trolls is an inconceivable process. There are too many bad trolls today. They new accounts to simply be annoying and so they can attempt to avoid a ban.

  • 11.22.2012 1:06 PM PDT

Hey I am a big Bungie fan ever since I played Halo 2. I love the series, I love Bungie. I have made a few Bungie logos in my metal shop.

Wait what so we have reached the maximum amount of accounts

  • 11.22.2012 1:16 PM PDT

Key


Posted by: SonicJohn
My brain died.

That's more numbers than peoples.
That made me laugh way too hard.

©

  • 11.22.2012 1:33 PM PDT

Per Audacia Ad Astra

Posted by: MozzarellaMonky
Wait what so we have reached the maximum amount of accounts
No, that would take another 1956 years at the current rate as stated in the OP.

  • 11.22.2012 2:13 PM PDT
  • gamertag: [none]
  • user homepage:

It was once said that a million monkeys at a million keyboards could reproduce the works of shakespeare... Now thanks to the internet we know that this is not true
==============================================
No programmer can pick up a TV remote without thinking what it would take to add a stun gun. [...] Their motto is 'if it ain't broke, it doesn't have enough features yet

Int32

  • 11.22.2012 2:43 PM PDT

Check out my Soundcloud account to hear some of my music.
Here's my twitter, in the off-chance you want that too.

Community Joe Interview: defnop552
Bye.

So what happens when it reaches that number? Do new members get deleted account numbers?

  • 11.22.2012 2:55 PM PDT

Key


Posted by: defnop552
So what happens when it reaches that number? Do new members get deleted account numbers?
No, they change your uID and get rid of all the uIDs of deleted accounts.

©

  • 11.22.2012 3:08 PM PDT

"Inveniam Viam Aut Facium" _~

if ( !now ){ when(); }

Posted by: defnop552
So what happens when it reaches that number? Do new members get deleted account numbers?
They go backwards.. (or switch to an UInt)

[Edited on 11.22.2012 6:58 PM PST]

  • 11.22.2012 3:16 PM PDT

Per Audacia Ad Astra

Posted by: defnop552
So what happens when it reaches that number? Do new members get deleted account numbers?
Bungie.net won't be here in the year 3967. Nobody will.

  • 11.22.2012 4:34 PM PDT

AV=http://avatar.coolclip.ru/albums/Avatars/Avatars%2090x90/A vatars_90x90_022.gif
BG=http://avatar.coolclip.ru/albums/Avatars/Avatars%2090x90/A vatars_90x90_022.gif

As you can see, this link produces erroneous results.

One member ID too much

Most likely an overflow and/or parsing error.

[Edited on 11.22.2012 5:38 PM PST]

  • 11.22.2012 5:34 PM PDT

Posted by: funkbrotha10
Int32
.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 in the application logic (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.

Posted by: defnop552
So what happens when it reaches that number? Do new members get deleted account numbers?
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. It's not like C++ where bits rollover, which is going to be a problem in the year 2038.

Interestingly, Twitter also faced this problem a few years ago too.

  • 11.22.2012 7:44 PM PDT
  •  | 
  • Fabled Legendary Member

I feel bad cause I knew the answer but didn't get to answer. I'm going to go cry now, bye.

  • 11.22.2012 7:49 PM PDT

Key


Posted by: dazarobbo
It's not like C++ where bits rollover, which is going to be a problem in the year 2038.

Interestingly, Twitter also faced this problem a few years ago too.
So basically the world will end. Sweet. Way to destroy the world, daza. I always knew it'd be an Australian who did it.

©

  • 11.22.2012 7:57 PM PDT

Tom Achronos
Bungie.net Overlord
twitter: http://twitter.com/Achronos

"I have no words that would do justice to the atrocities you commit to the English language, as well as your continued assaults on the concepts of basic literacy and logical reasoning."

Bungie.net's database (and most of its application code) define a user id as a SQL bigint (a signed 64-bit integer). It is signed because sql doesn't natively understand unsigned numbers, and constantly casting it is annoying. However, in the forum software (which was not written by us, just heavily modified by us) defines member ids as SQL ints (signed 32-bit integers). As it was originally created to have its own member database, it is kind of bolted onto our system (which is why you have two ids - when you see "memberID" in the URL, you're using the forum one).

One of the many things changing when bungie.next comes along is that silly complexity.

  • 11.22.2012 8:16 PM PDT

Subject: If you saw a meteor coming toward Earth, what would you do?Posted by: juniorbandit96
Butter my ass, turn around, spread open my butt cheeks, and say "Right here mutha-blam!-a!!"

Join Planetary Annihilation and Speed Haven

Posted by: Achronos
which is why you have two ids - when you see "memberID" in the URL, you're using the forum one
What is the second ID. Is it our unique username?

  • 11.22.2012 8:19 PM PDT

  • Pages:
  • 1
  • 2
  • of 2