Re: [Zope-dev] zope.sqlalchemy: Decoupling Zope3 and SQLAlchemy commit - how? Should I?

2008-11-03 Thread Brian Sutherland
On Sun, Nov 02, 2008 at 09:37:56PM +0100, Hermann Himmelbauer wrote: > Hi, > In one of my Zope3 projects, I use lovely.remotetask to run specific tasks in > background. These tasks do lengthy database operations via zope.sqlalchemy. > Currently, lovely.remotetask seems to do a Zope3 commit() at t

Re: [Zope-dev] zope.sqlalchemy: Decoupling Zope3 and SQLAlchemy commit - how? Should I?

2008-11-02 Thread Laurence Rowe
This depends on whether you have other resources involved in the transaction or not. I would assume that you will only have the sql database committing in the transaction, in which case it makes not a blind bit of difference if you commit separately or not - just make sure each individual task is a