Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Buffering vs Begin..End Transaction
Message
De
19/12/1999 13:36:54
 
 
À
17/12/1999 21:34:02
Jane Marie Ocampo
Innovision Systems International
Manila, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00305569
Message ID:
00305889
Vues:
22
>Which is a better approach in managing database?
>1. Pure Buffering feature
>2. Combination of Buffering and BEGIN/END Transaction
>3. Pure BEGIN/END Transaction
>
>What's the significance of Buffering feature in VFP when TRANSACTION can do what Buffering can?

You don't want to use transactions in place of buffering. Transactions are not designed to be used across user wait states. The amount of time and the number of lines of code between BEGIN TRANSACTION and END TRANSACTION or ROLLBACK should be kept to a minimum. Failing to do so can easily cause contentions between users, because transaction cause all records involved to be locked.

Buffering was designed to do what you need to do, and transactions were definitely not.
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform