Re: Re: using UID in DB

On Tue, Mar 30, 2010 at 2:27 PM, Nathan Rixham <nrixham@gmail.com> wrote: > nope never been able to find any significant advantage; and thus ended > up using http uri's in my own domain space(s) which are always > guaranteed to be unique as I'm issuing them. bonus is that they can be > dereferenced and server as both a universal (resource) identifier and a > locater. > > ps: resource = anything that can be named. > Hi Nathan, I'm interested in hearing your technique of generating your own uuid if you don't mind sharing :). I'm building a project to test my idea about search engine and testing of different RDBMSes. So naturally, it (the app) would crawl the net and I'd have over a 1 billion rows. Thanks, Tommy PS: Here are some info for those who haven't heard of UUID/GUID: http://affy.blogspot.com/2003/03/why-use-uuid-values.html http://www.mysqlperformanceblog.com/2007/03/13/to-uuid-or-not-to-uuid/