Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi all
According to page 159 of Certfox, a .DBC record is locked when a view is requeried AND this lock prevents others from doing a query until the results are returned. If that's true, it should be demonstrable with only 2 users and a query against a large table returning lots of records.
So, I tried it. Query progress bars were active on both machines, but if I interpret CertFox correctly, one machine should have had to wait.
It should be possible to show record contention with 2 users. Anyone have any code that could demonstrate this?
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement