On Thu, 20 Jun 2019 07:26:50 +0000, Nick Upson nu@... [firebird-support] <firebird-support@yahoogroups.com> wrote:

> ro_transaction = DB.trans(fdb.ISOLATION_LEVEL_READ_COMMITED_RO)
> cur = ro_transaction.cursor()
> else:
> cur = DB.cursor()
>
> I don't see any reason this should perform better but colleagues disagree
>

READ_COMMITED transactions, that are read only do not block
carbage collection. But that is only important for long-running
transactions.

--
Virgo Pärna
virgo.parna@...