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 > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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