|
Posted by csomberg on 10/02/87 11:30
SQL 2000
I have inherited an application where many of the automated processes
call a proc that simply returns the number of records with a NEW
status.
In watching the process in SQL, I see this ends up blocking a lot of
processes - many like this are called every 5-30 seconds ...
I wish to replace COUNT(*) with EXISTS if that will make things operate
faster with no locks ...
Thoughts ...
Thanks everyone !!
Craig
Navigation:
[Reply to this message]
|