Subject | RE: [firebird-support] Read-write transaction within a stored proc / optimisation |
---|---|
Author | Maya Opperman |
Post date | 2010-09-03T11:36:59Z |
>> I have set my reports (which rely of stored procedures for data) to use read-only transactions for speed.Yup, the transaction stays active as long as the result set is open on the screen (using FIBPlus and Delphi)
>There is no speed difference between read-only/read-write transactions.
>Or do you mean you use "permanently" started read committed transaction ?
>In FB2.5 you can use "autonomous transaction" inside SP.Sounds promising! Pity 2.5 is not released yet...