Subject | Re: [firebird-support] RO transaction |
---|---|
Author | Ann Harrison |
Post date | 2003-09-16T22:40:53Z |
Harri,
read_committed", it runs "precommitted" and has minimal effect on other
transactions.
will never be a conflict.
certain kinds of performance problems.
Regards,
Ann
>I did search with google and in IBPhoenix site, but didn't findPerhaps it just seemed too obvious.
>a clear definition for the "read only transaction".
>
>Also I rememberThat's true in Firebird. If you've declared your transaction as "read
>reading something like "readonly transaction is started in
>read committed mode and therefore does not stop OIT
>advancing .." but can't find this link any more :(
>
read_committed", it runs "precommitted" and has minimal effect on other
transactions.
>For myself, I prefer wait, but in this case it doesn't matter - there
>I'm using delphi+fibplus to access firebird database and as
>fiblus transaction component contains logic to use separate
>readonly and write transactions for dataset I would like to
>know, what transaction parameters to use?
>
>For now, I have these settings:
>- for readonly transaction
>"read, nowait, rec_version, read_committed"
>
will never be a conflict.
>- for write transactionFor write transactions, I prefer wait as it reduces the chances of
>"write, nowait, rec_version, read_committed"
>
certain kinds of performance problems.
Regards,
Ann