Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you decide the length of GUID field?
Message
De
08/08/2008 11:57:10
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
05/08/2008 05:10:30
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01336497
Message ID:
01337560
Vues:
17
>Hi,
>
>For me I normally set the length only base on my estimation on how large the table probably will grow.
>The larger the lengthier, things like 10, 12, 16, 24 or even 32 chars in length.
>
>I wonder what are the key factors everyone else is considering when trying to determine the length of a GUID field (let say it is used as primary/surrogated key field of tables).
>
>Is there any good article out there discussing how should one decide the length of a GUID field (be it a sequential one or non-sequential)?

c(36) works best in my experience (but maybe because I work with SQL server a lot). Perfromance would be affected is a myth IMHO. Search for COMB keys on the internet for details explicitly related to SQL server.

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform