Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
What should the primary key be?
Message
De
02/02/1999 21:37:41
 
 
À
02/02/1999 00:42:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00182646
Message ID:
00183253
Vues:
27
>Hiya Craig ----
>
>I hate @*#^@^&# integers :-)
>
>I used to use SYS(3), then went to SYS(2015) and now I'm quite happy generating GUIDs for primary keys.....any system which relies on an incremented number, in VFP, is suspect IMHO...now in SQL that's a different story.
>
>>
>>Actually, Mac went into great detail about why integer is better than character. There is an article on my website that discusses primary keys.

How much space does it take to store your GUID? Integers are small and VERY fast. Faster than character.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform