Re: UUID's ( maybe OT)

2002-09-19 Thread Jesse Houwing
Zac Spitzer wrote: > Bryan Love wrote: > >>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 nu

Re: UUID's ( maybe OT)

2002-09-18 Thread Zac Spitzer
Bryan Love wrote: > 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

Re: UUID's ( maybe OT)

2002-09-18 Thread S . Isaac Dealey
ings easier? Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > The url would be indexed :) > - Original Message - > From: "S. Isaac Dealey" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Wednesday,

RE: UUID's ( maybe OT)

2002-09-18 Thread Bryan Love
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

RE: UUID's ( maybe OT)

2002-09-18 Thread Tony Weeg
would be some built in functionality that made it a bit faster than a varchar with the same string of data in it. tw -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 5:18 PM To: CF-Talk Subject: RE: UUID's ( maybe OT) > but as a

RE: UUID's ( maybe OT)

2002-09-18 Thread Shlomy Gantz
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 >

Re: UUID's ( maybe OT)

2002-09-18 Thread Brian Thornton
The url would be indexed :) - Original Message - From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 1:12 PM Subject: RE: UUID's ( maybe OT) > I don't really know much abou

RE: UUID's ( maybe OT)

2002-09-18 Thread Dave Watts
> but as a datatype in SQL Server 2000 > wouldn't you imagine that m$ has made > it so that the sql server engines running it > are tuned to perform well with these? Well, ntext is a datatype in SQL Server, but I don't think you'd want to use it for your primary key fields. You might not have mu

RE: UUID's ( maybe OT)

2002-09-18 Thread Everett, Al
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)

RE: UUID's ( maybe OT)

2002-09-18 Thread S . Isaac Dealey
I don't really know much about most other vendors' cms, but this is one of the things I dislike about a number of cms that I've seen (from the outside anyway) ... I just don't see the need for a url like: http://www.metlife.com/Applications/Corporate/WPS/CDA/PageGenerator/0,1674,P 249,00.html (

Re: UUID's ( maybe OT)

2002-09-18 Thread Brian Thornton
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 us

Re: UUID's ( maybe OT)

2002-09-18 Thread Jeffry Houser
It depends what you want to do. In some cases, UUIDs are better for security purposes. The web surfer cannot easily guess the "next" in the line or simply change a URL variable to see something they shouldn't. ( And for the record, There was a way to avoid this Lotus Notes long complicat

RE: UUID's ( maybe OT)

2002-09-18 Thread Tony Weeg
but as a datatype in SQL Server 2000 wouldn't you imagine that m$ has made it so that the sql server engines running it are tuned to perform well with these? ..tony Tony Weeg Senior Web Developer Information System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.2337 -