Viewing 3 posts - 1 through 4 (of 4 total)
TheSQLGuru (8/24/2015)
Locking/blocking from a large transaction was the cause. Glad you had a simple fix! 20X improvement is AWESOME! :w00t:
Yeah, old code "is dark and full of terrors", but fortunately...
August 24, 2015 at 10:30 am
I've found workaround for this issue. I just splitted one huge transaction to many. One per iteration.
I tested it on saturday several times. Both one huge transaction and many small...
August 23, 2015 at 8:48 pm
Thanks for your reply, Kevin! I really appreciate that.
TheSQLGuru (8/21/2015)
1) (Re)compilation issues. You could try forced parameterization anyway to see if it helps. I have had GREAT success with that...
August 21, 2015 at 9:18 am
Viewing 3 posts - 1 through 4 (of 4 total)