> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ruaan Barnard
> Sent: Tuesday, August 02, 2005 5:23 AM
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Commit Retaining Transactions
>
> 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

I'm presuming that you don't want to commit so that you're not losing
the current cursor position? Have you considered saving that record key
and locating it (after commit and reopen the query)? Obviously this
isn't the best solution in all cases, but we've found it to work very
well in some.