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]

Reply via email to