Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Guid as PK
Message
From
22/03/2010 08:15:12
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
01455992
Message ID:
01456048
Views:
42
>In general, int PKs perform faster than GUID. You do know that you can utilize the negative range and also if you expect your table to grow really large, you can use BigInit.
>

Yes, I'm aware of the negative part

The question about faster is how much faster

Also. I want to be able to extract a subset of the db to put on a laptop, work on it and merge/sync it back later - hence the guid
Gregory
Previous
Reply
Map
View

Click here to load this message in the networking platform