Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GUID as PK
Message
 
À
07/12/2005 08:50:37
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Divers
Thread ID:
01075523
Message ID:
01075702
Vues:
26
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform