Hi



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
not?



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



TIA



Ruaan





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