Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GUIDS or Integers for primary keys?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00496066
Message ID:
00496075
Views:
12
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform