Subject RE: [firebird-support] Read-write transaction within a stored proc / optimisation
Author Maya Opperman
>> I have set my reports (which rely of stored procedures for data) to use read-only transactions for speed.

>There is no speed difference between read-only/read-write transactions.
>Or do you mean you use "permanently" started read committed transaction ?

Yup, the transaction stays active as long as the result set is open on the screen (using FIBPlus and Delphi)

>In FB2.5 you can use "autonomous transaction" inside SP.

Sounds promising! Pity 2.5 is not released yet...