On 11/16/16, Keith Medcalf <kmedc...@dessus.com> wrote: > What I do not > understand is why one would use a UUID (randomly generated bunch of bytes) > as a key in a database. It is long, every use must be checked for > collisions, and inherently far less efficient than the simple integer > sequence it is replacing.
If you use good randomness to generate the UUID and if the UUID is long enough, then you do not, in fact, need to check for collisions. It doesn't take an excessively long UUID to make the probability of collision become far less than the probability of a random cosmic ray hit on your CPU causing it to give the wrong answer on a collision test. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
