"integer overflow what will be next" Code Answer


think of it this way: how long did it take you to fill up an int? perhaps six months?

now multiply that time by roughly 4 billion.

that's how long it will take to fill up a bigint, if you insert data at the same rate. so if it took you half a year to fill an int, the bigint will last 2 billion years.

that gives you some scope of how much larger the range of a bigint is than an int. a bigint supports up to 264 values, which is 232 times larger than the number of values in an int.

By Hartmut Holzgraefe on July 8 2022

Answers related to “integer overflow what will be next”

Only authorized users can answer the Search term. Please sign in first, or register a free account.