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
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
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,
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
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
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
>
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
> 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
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)
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
(
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
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
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
-
13 matches
Mail list logo