On Sat, 11 Dec 1999 15:16:37 -0600
Paul DuBois <paul@stripped> wrote:
> At 9:38 AM -0800 1999-12-11, J C Lawrence wrote:
>> This can be expensive.
...
> I suspect that's not as expensive as the performance hit you'd
> take were the database engine to be doing what you seem to
> suggest: scan the table for the first hole in the sequence so that
> it can reuse an unused record. You'd have to do that for *every*
> insert, and it potentially would need to scan several million
> records.
No, I'd expect the engine to only do that when the incremented value
rolled over MAX_<type>, which is comparitively cheap. Ahh well, I
have work arounds.
--
J C Lawrence Home: claw@stripped
----------(*) Other: coder@stripped
--=| A man is as sane as he is dangerous to his environment |=--
