Re: Grabbing sequence values blocks in consecutive order: Need a guaranteed method.
- From: Jared Still <jkstill@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Thu, 26 Mar 2009 10:57:55 -0700
On Thu, Mar 26, 2009 at 10:06 AM, FmHabash <fmhabash@xxxxxxxxx> wrote:
> Jack,
> So am clear on what 'before' vs. 'behind' means in your reply.
>
> The example 2.001 ...
> - The '2' is incremented by a sequence.
> - 001 incremented by application .
>
>
That sounds like a very interesting solution.
If you used an integer of up to 15 digits, and used a
sequence that inremented by 10,000, your app would
have a hard time consuming all the available sequences
available.
Given 1000 sequences generated per second, 24x7, the
sequence would last for 3000+ years.
(9.99999999999999 * 10^14) / 10000 / 86400 / 365 = 3170.98 years
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
