Not really true. The word "terrible" is a vast overstatement.
Assuming you use char (or varchar) for the UUID (char is better since the
size is constant)...
The difference btwn string keys and numeric keys (performance-wise) is
pretty much null until you get up into the millions of records and even then
it's not enough to worry about.
Also, I saw a comment about nText. nText stores information in unicode so
each character in a string has an accompanying unicode key. This doubles
the storage size of strings and I believe it slows processing (although I'm
not sure on that one) so it's not generally a good idea. If you're gonna
use nText, nChar, nVarchar, make sure you have a really good reason!
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----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
> >
> >
> >
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
