Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-06-04 Thread Jim Starkey
On 5/30/2015 10:48 AM, Dmitry Yemanov wrote: 30.05.2015 11:29, Mark Rotteveel wrote: To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? I'm not aware of any place. I'd especially like to

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-31 Thread Mark Rotteveel
On 30-5-2015 17:13, Vlad Khorsun wrote: I'd especially like to know at which point the commit is executed, and the impact this has on open resources (cursor, blob, etc). As far as I understand commit_retaining is used. What impact does that have on visibility of transactions and resource use?

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-31 Thread Mark Rotteveel
On 30-5-2015 16:48, Dmitry Yemanov wrote: Autocommit is executed at the end of every execute/fetch DSQL API call and every start/send/receive/transact BLR API call, and *only* if that API call modified some data or posted some event. As a side effect, this means that a select from a stored

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Mark Rotteveel
On 30-5-2015 10:29, Mark Rotteveel wrote: To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? I'd especially like to know at which point the commit is executed, and the impact this has on open

[Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Mark Rotteveel
To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? I'd especially like to know at which point the commit is executed, and the impact this has on open resources (cursor, blob, etc). As far as I

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:53, Mark Rotteveel wrote: I'd also like to know when isc_tpb_autocommit was introduced. Somewhen before Firebird was created. Dmitry -- Firebird-Devel mailing list, web interface at

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Dmitry Yemanov
30.05.2015 11:29, Mark Rotteveel wrote: To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? I'm not aware of any place. I'd especially like to know at which point the commit is executed, and

Re: [Firebird-devel] Semantics of isc_tpb_autocommit

2015-05-30 Thread Vlad Khorsun
30.05.2015 11:29, Mark Rotteveel wrote: To better understand the implications of the pull request by Maxim, I'd like to know the semantics of isc_tpb_autocommit. Is this documented anywhere? AFAIR, no I'd especially like to know at which point the commit is executed, and the impact this