Identity Field

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply

How do you get your unique IDs?

Auto increment
4
67%
Key table
1
17%
Vendor Specific SQL (internal key database)
0
No votes
N/A, I use meaningful keys
1
17%
GUID
0
No votes
 
Total votes: 6

User avatar
Ambush Commander
DevNet Master
Posts: 3698
Joined: Mon Oct 25, 2004 9:29 pm
Location: New Jersey, US

Identity Field

Post by Ambush Commander »

Just wondering. I know what I use: a key table, and I'm not changing it any time soon, but I'm curious...
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

what I use depends entirely on what is needed for the particular case. The more secure it needs to be, the more I'll move toward an algorithmic but high entropy random generation (thus a key table) .. GUIDs I use for Windows programming interfaces ;) .. most often, auto-increment is used since a large amount of stuff only needs a simple sequential set of numbers.
Post Reply