> The most difficult part of this question is justifying WHY we would
> want to use random primary keys! There is a very strong reason for
> doing so, although not quite compelling.
One problem with using random generated primary keys that I've
recently read about deal with insert failing do to primary key
duplication.
If the size of your dataset grows to become a significant percentage
of the size of the integer type used for your random primary key,
the probability of inserting a duplicated number dramatically
increases. I imagine that this problem could contribute to poor
preformance for large bulk inserts that have to add logic for
dealing with re-trying a insert if a duplicate number is created.
Regards,
Richard Broersma Jr.
