Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #81650

Re: Db transactions and locking

Show all headers | View raw

On Fri, Nov 28, 2014 at 5:02 AM, Ian Kelly <ian.g.kelly@gmail.com> wrote:
> On Nov 27, 2014 4:26 AM, "Frank Millman" <frank@chagford.com> wrote:
>> All Python database adaptors that I have used start a transaction when you
>> open a cursor. I have just re-read DB-API 2.0, and I cannot see anything
>> that specifies this behaviour, but AFAICT this is what happens.
>
> I don't know how others work, but cx_Oracle starts a transaction when you
> execute a statement, not when you open a cursor.

Is there any material difference here? I mean, sure, you have a
transaction, it'll show up in logs and stuff, but without any locks,
it's unlikely to have much impact on the system. Unless you're
creating and destroying a bunch of unnecessary cursors all the time,
of course, but that'd be wasteful for other reasons.

ChrisA

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Re: Db transactions and locking Chris Angelico <rosuav@gmail.com> - 2014-11-28 09:36 +1100

csiph-web