Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Surrogate Primary Keys - Integer or Character ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00397596
Message ID:
00399911
Vues:
17
Last I checked, Combo boxes play nicer with char surogate keys than integers.

Not that you asked for this, but for the record, here are some times that show how much faster ints are: http://fox.wikis.com/wc.dll?wiki~IntVsChrSpeed~VFP

>The only good reason I can think of to use a character based primary key is that it allows for the use of concatinated keys. This ability doesn't seem to out-weight the performance issues so why would I ever use a character based primary key? Am I missing the boat here? Is there some hidden advantage to it? If not, why do most all of the frameworks I have looked at default to it?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform