- Deadlocks: direct SELECT statements against the database take shared read locks at the default transaction level, and can violate our lock hierarchy, leading to seemingly random failures.
- Incorrect data: if you avoid taking locks to avoid a deadlock, you’ll very likely observe the database in an intermediate state and retrieve incorrect data.
Read this page in your own language
Wednesday, December 30, 2009
Hazards : Sharepoint Database Reading\Accessing
Even reading from the database can indeed have negative effects on performance and stability. Just to name two such effects, I’ll paraphrase his comments:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment