No, the loop is not inside the Atomic Transaction. The Loop is in a Long Running Transaction Orchestration. The Orchestration is a long transaction because it calls some atomic transactions, then there were also Map Transformation inside the loop too. What difference does it make if the loop is inside the atomic transaction and the long running transaction? Is atomic transaction more advisable than long running transaction?
Well, on the difference side, my sample biztalk took about 4 millisecond difference between Biztalk & assembly however on actual Biztalk application, the difference was pretty big. I’ve tried the actual change on another Biztalk project by putting the loop from Biztalk to Assembly. It takes 5 to 7 seconds to run through per line time in Biztalk, and in the end it would take more than 1 minute for 20 line items. I’ve tried it in assembly it was less than a minute, even less than about 30 sec as a whole. My point here is that what if the line items would go over 500, then it would take more 30 minutes to process 500 records on Biztalk, that would be bad.