Subject Commit Retaining Transactions
Author Ruaan Barnard

I am trying to find the best solution for a long running transaction.

What would be the best solution of the 2 methods I describe and why or why

1] Use 2 transactions - one for read and one for write and commit the write
transaction every 100 records or

2] Use 1 transaction with CommitRetaining every 100 records and a hard
Commit at the end.

Any other suggestions would also be welcome



[Non-text portions of this message have been removed]