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
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
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
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
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
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
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
-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
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
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
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
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
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
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
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
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
]]
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
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
18 matches
Mail list logo