>problem with a pk field is that if something about that
>table/record/database gets corrupted, you will never be able to
recreate
>that number in the pk field. where a uuid, you could, in theory
>recreate it.
Well you could recreate an identity with a new auto generated number and
just update all the child records with the new id. Even if you generate
a new UUID, you still need to update all the child records as well, so
the same problem holds for both. The problem is that you cannot
manually edit an identity field, where in a UUID, you could.
-----------------------------------------------
Kevin Kazmierczak, CCNA
Certified Advanced ColdFusion MX Developer
Alfred University
Alumni Hall
607-871-2334
[EMAIL PROTECTED]
_____
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:22 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
yeah, but how often do i manually put an order number in somewhere?
usually its from a link or some other method that the order number or
whatever gets in the url string. but then again, you can do whatever
you like, just doesnt seem like something that is necessary to create if
you already are creating the uuid as the key on that order (in your
example)
and mikey brought up a good idea on aim with me earlier. the real
problem with a pk field is that if something about that
table/record/database gets corrupted, you will never be able to recreate
that number in the pk field. where a uuid, you could, in theory
recreate it.
so, whatever, its a matter of what you feel comfortable with.
tony
-----Original Message-----
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:16 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
but the UUID is a long text field, right... xxxxxx-xxxxxx-xxxxxx or
whatever...
Hard for people to remember that as a client id or order id....I would
think...or am I on the wrong page here?
Regards,
Eric
"The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all
progress depends on the unreasonable man."
-- George Bernard Shaw
_____
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:14 PM
To: CF-Talk
you could use the uuid as your order number, no need for the autoIncrId
field, i dont think?
-----Original Message-----
From: Eric Hoffman [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 11:09 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
So then, in theory, if we are utilizing the int autoid to generate a
customer number or order number....we in theory should/could still be
using
UUID() for future growth potential...does that make sense, a UUID as the
PK
and still use the autoid int field...spose it doesn't matter....is that
how
y'all handle it?
Regards,
Eric
"The reasonable man adapts himself to the world; the unreasonable one
persists in trying to adapt the world to himself. Therefore all
progress depends on the unreasonable man."
-- George Bernard Shaw
_____
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:02 PM
To: CF-Talk
and in doing this, even with a large table, you find no performance hit
on sql server indexing that column and/or query on that table and using
that column in the where clause?
tony
-----Original Message-----
From: Stacy Young [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:51 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
I've begun to use UUIDs much more often these days...
Stace
_____
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: November 10, 2003 10:43 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll
UUIDs
Unless your database is going to house a terabyte worth of info, the
perofrmance hit is negligable and you will be all set for merges in
replication, easier time porting to different platform, etc...
I have never been a big fan of identities and have never worked with any
DBAs who have been. This topic has been discussed before, lets not blow
it
out of the water again.. search the archives.
_____
From: Sutton Yamanashi [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 9:09 PM
To: CF-Talk
Subject: Primary key preference quick poll
Why do you prefer
1. int (Identity / auto_increment)
2. char maybe with CreateUUID()
3. varchar
other?
Thanks!
-sutton
_____
_____
_____
_____
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
