oh, and why...cause integer fields, would almost have to index better
that a mixed character field.  even tho' its a native sql server data
type
i cant imagine that its easier to index than a simple integer field.

tony

-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 9:16 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll

id int auto increment

tony

-----Original Message-----
From: Jeff Garza [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 9:13 PM
To: CF-Talk
Subject: RE: Primary key preference quick poll

I prefer Identitity myself... we don't do any cross server replication,
so
we don't need UUIDs.


Cheers,


Jeff

  _____  

From: Sutton Yamanashi [mailto:[EMAIL PROTECTED]
Sent: Monday, November 10, 2003 7: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