| Subject | Re: Maximum number a generator will reach |
|---|---|
| Author | Adam |
| Post date | 2007-04-02T12:45:46Z |
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:
generator to 0 dml.
In a Dialect 3 database, and if my math is working tonight, if you
dish out 1 million generator values per second, you should be ok for
the better part of 300,000 years.
Adam
>It would not roll over on that number. Check that no-one is using set
> At 05:50 PM 2/04/2007, you wrote:
> >Hi,
> >
> >What is the maximum number a firebird generator will reach before
> >resetting to zero? I've seen 140372906 but it does not make sense
> >that the generator will automatically go back to zero after hitting
> >that number.
generator to 0 dml.
>^
> In a dialect 1 database, its highest positive number is 2,147,483,647
> (it is a 32-bit integer in that environment).
>
> In a dialect 3 database, the highest positive number is
> 9,223,372,036,854,775,807 (it is a 64-bit integer in dialect 3)
In a Dialect 3 database, and if my math is working tonight, if you
dish out 1 million generator values per second, you should be ok for
the better part of 300,000 years.
Adam