I should have been more specific,
the python code is done as
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
Kind Regards,
Nick
Nick Upson | Principal Operations Engineer
office +44 01799 588800 support hotline +44 1799 399200
DDI +44 01799 588621
telensa.com<http://www.telensa.com/> | @telensa<http://www.twitter.com/telensa>
| Linkedin<http://www.linkedin.com/company/telensa>
________________________________
From: [email protected] <[email protected]> on
behalf of Dimitry Sibiryakov [email protected] [firebird-support]
<[email protected]>
Sent: 19 June 2019 16:59
To: [email protected]
Subject: Re: [firebird-support] rw vs ro connections
19.06.2019 17:51, Nick Upson [email protected] [firebird-support] wrote:
> Should I expect any performance gain if I change my rw connections to ro,
> given that the
> query is always of the form "select * from ..."
At first, there is no such things as "ro connection".
At second, ro transactions have no performance advantage.
--
WBR, SD.
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
CAUTION. This email originated from outside of Telensa. Do not click links or
open attachments unless you recognise the sender and know the content is safe.
IMPORTANT NOTICE: This e-mail message is intended to be received only by
persons entitled to receive the confidential information it may contain. E-mail
messages to clients of Telensa may contain information that is confidential and
legally privileged. Please do not read, copy, forward, or store this message
unless you are an intended recipient of it. If you have received this message
in error, please forward it to the sender and delete it completely from your
computer system.
