Subject Re: [firebird-support] rollback or commit
Author Helen Borrie
At 05:29 PM 10/09/2003 +0100, you wrote:

>Daniel,
>
> > If not mistaken, there's no difference.
>
>If not mistaken, I think that a commit will give you less overhead that a
>rollback.
>
>But this is just a feeling. :-)

It's a fact, provided the transaction read-write attribute is true (the
default). For a read-write transaction the engine sets things up for
creating and rolling back new record versions if required. Cleaning up
after a Commit costs less than cleaning up after a Rollback.

But for a transaction set to be readonly, there is no difference.

Helen