RE: TR: UUID's ( maybe OT)

2002-09-20 Thread S . Isaac Dealey
> In my previous mail, I was not saying, that Vignette > naming was a great one. I was just explaining that > it was linked to the way their caching system works. > > I definitely agree : if you can have "friendly URL", > you should keep them friendly (and avoiding UUID > is already one way to do

RE: TR: UUID's ( maybe OT)

2002-09-20 Thread Benoit Hediard
age d'origine- De : S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 19 septembre 2002 23:27 À : CF-Talk Objet : Re: TR: UUID's ( maybe OT) > "I just don't see the need for a url like: > http://www.metlife.com/Applications/Corporate/WPS/CDA/Page > Ge

Re: TR: UUID's ( maybe OT)

2002-09-19 Thread S . Isaac Dealey
> "I just don't see the need for a url like: > http://www.metlife.com/Applications/Corporate/WPS/CDA/Page > Generator/0,1674,P > 249,00.html" > Just for your information, Vignette use > "0,1674,P249,00.html" URL format for > caching purpose. > The name of the file contains all the parameters used

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

TR: UUID's ( maybe OT)

2002-09-19 Thread Benoit Hediard
Isaac Dealey [mailto:[EMAIL PROTECTED]] Envoyé : mercredi 18 septembre 2002 22:13 À : CF-Talk Objet : RE: UUID's ( maybe OT) 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 outsi

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
ade > 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 > -Original Message- >

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

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
.2337 -Original Message- From: Zac Spitzer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:16 PM To: CF-Talk 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 ex

UUID's ( maybe OT)

2002-09-18 Thread Zac Spitzer
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 b