Subject Re: [ib-support] minimizing transaction-open time
Author Doug Chamberlin
At 05/08/2002 10:37 AM (Wednesday), Woody wrote:
>Moving between
>records then becomes: start transaction, read record, edit (or not), stop
>transaction, start transaction, read record, etc., etc.

Actually a much better way is

Start trans
Read record
Commit
Let user edit record taking all the time they want.
When they save:
Start trans
Write updates
Commit