http://www.codebits.com/uuid/index.htm
a great explanation about why you should use UUID (by David Medinets). Personally I use UUIDs for large applications since it solves a lot of problems in synchronization and aggregation of content and data from globally distributes sub-systems. However, in many cases UUID are just plain overkill. I use UUIDs in Oracle more than in MSSQL simply because the affect on performance is very minimal in Oracle. my 2c Shlomy -----Original Message----- From: Everett, Al [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:33 PM To: CF-Talk Subject: RE: UUID's ( maybe OT) My DBE tells me, however, that UUIDs (or GUIDs) are terrible for joins. Better to just use integers. > -----Original Message----- > From: Brian Thornton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 3:59 PM > To: CF-Talk > Subject: Re: UUID's ( maybe OT) > > > UUIDs with a datatype of uniquidentifier are indexed just as pk's > > > ----- Original Message ----- > From: "Zac Spitzer" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday, September 18, 2002 10:15 AM > Subject: UUID's ( maybe OT) > > > > I am probably OT here, but I see so many people using UUID's when > > simpler normal numeric keys are better... a classic example > for me is > > article id's... look at cfcomet for example... the article > ids aren't > > user friendly, it reminds me of good old lotus notes and we > all know how > > short urls are better than long one ( email wrapping for example ) > > > > not to mention that your database and CF load is much > higher using long > > text pk's than with nice short numeric keys and your page size is > > increased a lot too.. > > > > just letting off steam..... don't want to create a flame > war or anything > > > > z > > > > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists