Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GUID as PK
Message
 
To
07/12/2005 08:50:37
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Miscellaneous
Thread ID:
01075523
Message ID:
01075702
Views:
25
>Hi Einar
>
>http://www.sql-server-performance.com/zn_guid_performance.asp
>
>http://www.informit.com/articles/article.asp?p=25862&rl=1
>
>Interestingly enough, the second article despite proposing something faster than the GUID fails to examine the advantages of having many clients generate their own PK. I always think about the server in terms of a subway. The more people who take their time getting on and off the subway before it comes to my station, the longer I have to wait. The server could be spared the task of generating the key.

Mike,
Thanks for your reply and the links. Do you use a GUID for PK in your tables?

Einar
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform