Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Guid as PK
Message
De
22/03/2010 08:15:12
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Divers
Thread ID:
01455992
Message ID:
01456048
Vues:
43
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform