Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AutoInc value and CA
Message
 
To
02/02/2007 12:25:51
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01191628
Message ID:
01192248
Views:
26
>Hi Borislav
>
>You realize you're hitting the backend/table 3 times? Once to grab the record, once to send the update and once to grab the new ID?
>
>That's the kind of thing DBAs complain about.
>
>By using GUID there are no extra round trips required to get new ids.

No, only two times, send insert command and grab newly created id for that record. I am not sure is DBAs will be most happy when I create a 36 bites GUID instead of 4 bites Integer. I will have 4 bites transfer when I ask about new Id, and 4 bites for every single records when I want some recordset, but if I use GUID I will have 32 more bites to transfer for every record in the same recordset, isn't it?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform