Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
View DBC Contention
Message
De
25/08/2011 15:55:28
Joel Leach
Memorial Business Systems, Inc.
Tennessie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
View DBC Contention
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01521812
Message ID:
01521812
Vues:
114
As you are probably aware, VFP locks records in the DBC when opening a view. If multiple users access the same DBC, there can be contention and delays while VFP waits for a lock. For this reason, it is common to put a separate copy of the view DBC on each workstation. The same problem can occur with ParallelFox, but at a local level. Multiple workers (instances of the same EXE) can hit the view/DBC at the same time and cause contention issues. To work around this, I have compiled the DBC into the EXE, thinking that each worker would essentially get its own copy of the DBC. However, "Attempting to lock..." still blinks while multiple workers access the same view. Anyone know what happens behind the scenes when you compile the DBC into an EXE? Is it copying it to a temp location and sharing it across all EXEs?

Thanks.
Joel Leach
Microsoft Certified Professional
Blog: http://www.joelleach.net
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform