Subject | Re: [ib-support] Generator Limits and How to Cope |
---|---|
Author | Lucas Franzen |
Post date | 2001-10-02T10:20:27Z |
Ivan Prenosil schrieb:
And maybe some people like to sort on the generated value - than the
records that will be added after the generator rolled over will be the
first ones :-))))
I personally always felt on the safe side with 2 billion positive
values...
Luc.
>No, it's just that a created generator is starting at 0.
> > it's 68 years.
> > 32 bit signed is 2.17 Billions in the positive range.
> > One day has 86400 seconds, so an average year has 365.25 * 86400
> > seconds.
> >
> > 2.17 * 10^9 / 86400 / 365.25 =~ 68 (years)
>
> People keep inventing complicated methods how to save unused
> precious generator values, and you throw away 2.17 Billions of them
> just because they are in negative range ?? :-)
And maybe some people like to sort on the generated value - than the
records that will be added after the generator rolled over will be the
first ones :-))))
I personally always felt on the safe side with 2 billion positive
values...
Luc.