Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Locking records
Message
 
 
À
06/02/2007 14:35:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 7
Divers
Thread ID:
01192613
Message ID:
01192961
Vues:
18
>So if you lock a record in a table that's at or close to the 2GB limit, one of the other records gets a lock placed on it, preventing other instances of VFP from reading that file. This can result in unusual behavior, and, possibly, a Dead Lock scenario.
>
>Please note that this does not affect a "single-user" table, as a process can read through it's own locks.
>
>The formula for finding the amount of potencially affected bytes is roughly:
>
>((Header() + (RecSize() * RecCount() + 1)) - ((2^31) - RecCount()))
>
>Also note that adding a CDX to the table does not cause this bug to go away.

>
>There does seem to be an exposure, but apparantly only when the table is very close to the 2GB limit. Since that's the scenerio we are trying to avoid (the tables will be packed if they get beyond 1.7 GB), it seems to be OK for us.
>
>Thanks again...........Rich
>

You're welcome.
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform