RE: TR: UUID's ( maybe OT)

2002-09-20 Thread Benoit Hediard
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 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

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 it). Why

Re: UUID's ( maybe OT)

2002-09-19 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 the

TR: UUID's ( maybe OT)

2002-09-19 Thread Benoit Hediard
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 outside anyway) ... I just don't see the need for a url like: http://www.metlife.com/Applications

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 null until you

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 to

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

RE: UUID's ( maybe OT)

2002-09-18 Thread Tony Weeg
-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 example for me

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

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 using

RE: UUID's ( maybe OT)

2002-09-18 Thread S . Isaac Dealey
System Design Navtrak, Inc. Fleet Management Solutions www.navtrak.net 410.548.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

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) UUIDs with a datatype

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 much

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 about most other vendors' cms, but this is one of the things

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 Subject: Re: UUID's ( maybe OT

RE: UUID's ( maybe OT)

2002-09-18 Thread Tony Weeg
that there 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 datatype

RE: UUID's ( maybe OT)

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

Re: UUID's ( maybe OT)

2002-09-18 Thread S . Isaac Dealey
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, September 18, 2002 1:12 PM Subject: RE: UUID's ( maybe OT) I don't really know