Subject | RO transaction |
---|---|
Author | harri007et |
Post date | 2003-09-14T14:26:53Z |
Hi!
I did search with google and in IBPhoenix site, but didn't find
a clear definition for the "read only transaction". Also I remember
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 :(
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"
- for write transaction
"write, nowait, rec_version, read_committed"
FIBlus team suggested to ask here, so please don't direct me
back to them :-)
regards,
Harri
I did search with google and in IBPhoenix site, but didn't find
a clear definition for the "read only transaction". Also I remember
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 :(
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"
- for write transaction
"write, nowait, rec_version, read_committed"
FIBlus team suggested to ask here, so please don't direct me
back to them :-)
regards,
Harri