Re: One sequence or many sequences?
From: William Robertson <williamr2019_at_googlemail.com>
Date: Sat, 28 Jun 2008 16:07:05 -0700 (PDT)
Message-ID: <8c969cca-b58f-478b-8f0b-966f26b8e2f4@y21g2000hsf.googlegroups.com>
Date: Sat, 28 Jun 2008 16:07:05 -0700 (PDT)
Message-ID: <8c969cca-b58f-478b-8f0b-966f26b8e2f4@y21g2000hsf.googlegroups.com>
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