摘要
死锁问题虽然不能完全避免,但可以使死锁的数量减至最少。越早的考虑数据库设计中的并发性问题,就越可以提高代码执行的效率,降低程序开发和维护的成本。本文从死锁产生的原因谈起,提出了一些在SQL SERVER中避免和解决死锁的方法。
The deadbolt lock question although cannot completely avoid,but may cause the deadbolt lock the quantity to reduce to few. In the earlier consideration database design concurrency question, more may enhance the code execution the efficiency,reduces the procedured evelopment and the maintenance cost. This article the reason which produces from the deadbolt lock mentions,proposed some avoid in SQLSERVER with the solution deadbolt lock method.
出处
《科技创新导报》
2010年第23期35-35,共1页
Science and Technology Innovation Herald
关键词
死锁
资源竞争
提交
回滚
隔离级别
事务
DeadLock Resource competition commit rollback transaction