Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GUID for a primary key?
Message
From
26/07/2021 09:05:02
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
24/07/2021 09:37:30
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01681922
Message ID:
01681934
Views:
85
>Hello all,
>
>To me it looks like a no brainer. When creating a primary key for a table I use a guid.
>
>I'm wondering about something. Why would you use anything else?
>
>Regards

Because it doesn't solve all problems too. And it's laaarge overhead. A table with 10 relationships gathers a lot of space. it's what 176 bytes + index if you store it as byte, or 418bytes if stored as full char expression (352byte unformated)
It's just about the usage - do you need to merge data over different systems and so on.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform