On Tue, Jul 16, 2002 at 03:56:23PM +0100, Alex McLintock ([EMAIL PROTECTED]) wrote: > At 10:47 16/07/02, Roger Burton West wrote: > >On or about Tue, Jul 16, 2002 at 10:43:17AM +0100, Peter Haworth typed: > > > > >Surely you shouldn't rely on sequences being contiguous, anyway? Who cares > > >if your test eats up some values; their only purpose should be to ensure > > >uniqueness. > > > >Contiguity becomes important when you're doing things like generating > >invoice numbers. > > For the record I hit this sort of problem doing some perl web stuff with > Oracle. > It seemed that because Oracle was multiprocessor each oracle process would > grab for itself the next 20 ids. if you stopped and started the server > there would be a gap of 19 between consecutive requests....
Sybase has a similar feature - except each process grabs about a million ids. This leads to some very confusing numbers. Dave... -- It was long ago and it was far away And it was so much better that it is today