2.9 million identifiers can be created per second for the next 100 years before we overflow a BIGINT.
And that's assuming we ONLY use the positive side of ZERO. We didn't even calculate the negative Identifiers we could create. Effectively this doubles the available Identifiers we have.
In my mind, BIGINT really is a BIG datatype.
Dave Wentzel CONTENT