Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.03.2018 9:30, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: > and in Firebird 3 when using the old API (most applications use > the old API). Actually 64k limit is applied to statement in ISC API only if length of statement is indicated explicitly and function declarations

Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-3-2018 02:12, ho...@agencybusys.com [firebird-support] wrote: > Thank you, Mark, for such a complete and clear answer. You are a big > help to me. What you said agrees and helps me understand what I have > read. What I was concerned about was my Execute Blocks were too big, and > had to

[firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-12 Thread ho...@agencybusys.com [firebird-support]
Thank you, Mark, for such a complete and clear answer. You are a big help to me. What you said agrees and helps me understand what I have read. What I was concerned about was my Execute Blocks were too big, and had to be split into several smaller blocks. I wanted to make sure all the blocks

[firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-12 Thread ho...@agencybusys.com [firebird-support]
Thank you Karol, I did not want Parallel, so good news.

Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-12 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-03-12 18:08, ho...@agencybusys.com [firebird-support] wrote: > I didn't see a way to edit the previous post, so sorry for this > afterthought. > > My concert are: > > 1. Since the EBs are executed on the Server, will a transaction > created in Delphi have any benefit for controlling the

Re: [firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-12 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
Hi, One transaction have benefits like integrity. If your process must be accomplished as a whole it is only good way for this. Your statments are executed serial. For parallel you will need many connections at the same time. Regards,Karol Bieniaszewski null

[firebird-support] Re: Can many Execute Blocks be within a Transaction.

2018-03-12 Thread ho...@agencybusys.com [firebird-support]
I didn't see a way to edit the previous post, so sorry for this afterthought. My concert are: 1. Since the EBs are executed on the Server, will a transaction created in Delphi have any benefit for controlling the sequence of execution, or the ability to roll back if a failure occurs in block