what is the reason of having nested transactions inside the Worker method?
The idea is to check that TCOMMIT works, for additional safety, but yes, inner pair of TSTART/TCOMMIT can be taken out.
And how can you distribute single ("root") transaction execution and control among several processes?
No problems with that, transaction iterates over history data, so it's possible to chunk it.
another approach
Thank you. Locking situation would be better with this approach.
- Log in to post comments
.png)
.png)