Re:Extracting timestamp and MAC address from UUIDs
by elmin on Friday November 07, 2014 @08:32PM
(#8575663)
An alternative that was posted here a week or so ago: https://eager.io/blog/how-long-does-an-id-need-to-be/
[ Parent
| on HN ]
Re:Extracting timestamp and MAC address from UUIDs
by klodolph on Friday November 07, 2014 @11:51PM
(#8576065)
Or you could just use type 4 UUIDs. We know 64 bits is likely too small, and 128 bits is likely enough. Why bother saving a few bits here and there, if you already have a working solution?
Re:Extracting timestamp and MAC address from UUIDs
by girvo on Saturday November 08, 2014 @01:46AM
(#8576243)
For unique IDs in databases, you want them to have common prefixes such that they are kept in rough time order in the database's backend, otherwise your indexes can end up huge and degrade performance (especially in MySQL, that's where we got bitten by it). That's where Type 1s are great, but of course this article shows a major downside.