December 2002
Intermediate to advanced
928 pages
85h 29m
English
The locks used to enforce isolation between concurrent users of data can lead to their own problems. As the example described in the previous section illustrates, a single transaction could cause significant performance problems as the locks it places on the database prevent other transactions from completing. The interference caused by conflicting locks is called contention. Contention can degrade the performance of the database.