Re: sequence omits numbers?

From: Scott Gamble <zifnab_at_islandsofmyth.remove.org>
Date: Tue, 05 Aug 2003 11:31:57 -0500
Message-ID: <Xns93CE75512F06zifnabislandsofmytho@206.127.4.21>

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote in news:E2F6A70FE45242488C865C3BC1245DA703FE3663_at_lnewton.leeds.lfs.co.uk:

> Hi Stephan,
>
> 'nocahce' will incur performance penalties if the sequence is hit a lot.
>
> The best solution is to pin the sequence in memory, then you have the
> best of both worlds - fast(er) responses because the values are cached,
> and no loss of cached values (unless shutdown abort called).
>
> Cheers,
> Norm.

A rollback will leave the same gaps too will it not? Received on Tue Aug 05 2003 - 11:31:57 CDT