Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
AutoInc value and CA
Message
 
À
02/02/2007 12:25:51
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01191628
Message ID:
01192248
Vues:
17
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform