[sqlalchemy] Re: session transaction slow

2007-05-23 Thread Michael Bayer
On May 23, 2007, at 5:46 PM, [EMAIL PROTECTED] wrote: > Just to follow up on the issueI was able to trace the momentary > deadlock to a call to > user.groups.append(Group.get_by(group_name='somegroup')) during the > setup of new contact.user. oh and what happens then, the backref on "Group"

[sqlalchemy] Re: session transaction slow

2007-05-23 Thread gmarshall
On May 22, 12:29 pm, [EMAIL PROTECTED] wrote: > > On May 22, 2007, at 2:12 PM, [EMAIL PROTECTED] wrote: > > >> I have a transaction that uses save_or_update() and takes 2-3 minutes > >> to execute: > > >> There's some setup before the transaction (pseudocode for brevity) > > >> contact = Contact

[sqlalchemy] Re: session transaction slow

2007-05-22 Thread gmarshall
> > > On May 22, 2007, at 2:12 PM, [EMAIL PROTECTED] wrote: > >> >> I have a transaction that uses save_or_update() and takes 2-3 minutes >> to execute: >> >> There's some setup before the transaction (pseudocode for brevity) >> >> contact = Contact() >> # ...set props on contact >> >> contact.use

[sqlalchemy] Re: session transaction slow

2007-05-22 Thread Michael Bayer
On May 22, 2007, at 2:12 PM, [EMAIL PROTECTED] wrote: > > I have a transaction that uses save_or_update() and takes 2-3 minutes > to execute: > > There's some setup before the transaction (pseudocode for brevity) > > contact = Contact() > # ...set props on contact > > contact.user = User() > # .