Mike Yearwood
Toronto, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only