Re: Grabbing sequence values blocks in consecutive order: Need a guaranteed method.

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: