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. >Roger
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.... Alex Openweb Analysts Ltd, London. Software For Complex Websites http://www.OWAL.co.uk/ Open Source Software Companies please register here http://www.OWAL.co.uk/oss_support/
