Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GUIDS or Integers for primary keys?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00496066
Message ID:
00496075
Vues:
13
>What are the Pros and Cons of using GUIDs vs Integers for Primary Keys on a Web based application.

In either case, (unless your backend is SQL Server) you have to generate the value. There are some factors that you should consider. If your backend is a native VFP table, the GUID will have to be stored as character and will take up 32 bytes. OTOH, an integer PK takes up only four.
George

Ubi caritas et amor, deus ibi est
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform