Re: One sequence or many sequences?
Date: Sat, 28 Jun 2008 16:07:05 -0700 (PDT)
On Jun 27, 5:18 pm, Mark D Powell <Mark.Pow..._at_eds.com> 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