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:
  • 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.
By doing this,you will run the risk of breaking or degrading the performance/stability of technology we built to be fast and robust. The odds of a database change in our next Service Pack aren’t small. It’s that you’ll on your own if anything goes wrong. Consider this carefully.

No comments: