Having a staging environment with a daily dump of live data and software would be nice. you can mess with the data as much as you want. Obviously that involves a lot of work to set-it up the first time and probably extra hardware. The other advantage is to have nice release procedure where you release on staging any changes before committing them to live.
Pierre > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Roger Burton West > Sent: 16 July 2002 10:47 > To: [EMAIL PROTECTED] > Subject: Re: mysql autoincs > > > 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 >