J
James Palmer
Guest
Oooh that's a nice can of worms opened. I don't know how to solve your particular problem in .net. What I do know is that you are doing something that (in my opinion) is bad practise. Your transaction scope here is rather large. It should be kept as tight as possible, locking as few records as possible. You run the risk of all sorts of problems like lock table overflows, and contention issues with a strategy as you describe.
Continue reading...
Continue reading...