about them. I still think that identities are great for small tables,
but if you will need to mix information from replicated databases, it
would become a pain. Also, I like the idea of having a globally unique
key for a record in the database, so I vote with UUIDs.
You like that Mike?
Kevin.
_____
From: Michael T. Tangorre [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 10:40 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]
