February 1, 2003 at 2:33 pm
Shouldnt the duration of the lock matter more than the number? Considered just making it a permanent table (even if still in tempdb) and adding spid as a column. A minor tweak, but you'd avoid the table creation step altogether and just be back to managing standard locking issues.
Andy
February 1, 2003 at 4:43 pm
ya the lock duration is the main thing. My point was the SELECT..INTO has more overhead with locks.
What will a perm. table with the spid as a column do?
February 2, 2003 at 4:28 am
Means you only create it once, so the blocking issue should just about go away. Probably need to index it to make it effective. Then any place you would have just select * from a temp table, its now select * from permtable where spid=@@spid. Matching insert of course.
Andy
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply