I have a busy transactional table , I wanna use row level locking mechanism in msSQL.
SELECT * FROM PARTYWITH (UPDLOCK ROWLOCK)
where LastName ='Clinton'
is there anydownsides of this approach?
Here's a pretty good article talking about the pro's and con's
http://www.sql-server-performance.com/lock_contention_tamed_article.asp
From what I can tell, the only disadvantage, isnt specific to ROWLOCK itself, just locking in general in busy tables.
No comments:
Post a Comment