Re: One sequence or many sequences?

From: William Robertson <>
Date: Sat, 28 Jun 2008 16:07:05 -0700 (PDT)
Message-ID: <>

On Jun 27, 5:18 pm, Mark D Powell <> wrote:
> Otherwise the low use sequences are flushed from the sequence pool before reuse and more
> numbers are thrown away by the flushing than are used.

There's a sequence pool?

The performance will depend on the number of updates of sys.seq$. If you expect a single sequence to get a lot of use you might want to increase the cache size. The term "cache" does not mean there is a list of numbers actually held in memory somewhere. Received on Sat Jun 28 2008 - 18:07:05 CDT

Original text of this message