[sqlalchemy] Re: Set expire_on_commit to False to improve commit performance

2011-12-11 Thread Amir Sasson
e newly created port. This problem did not occur when expire_on_commit was set to True. As I understand the problem occures since the appropriate host instance is not expired after the commit. Is there any way overcome this issue, without expiring all the DB instances ? Thanks, Amir On Nov 28,

[sqlalchemy] Set expire_on_commit to False to improve commit performance

2011-11-28 Thread Amir Sasson
Our Application is using a single session to access the DB. This session is opened when the Application is started and closed when the Application is terminated. The Application holds references to all the DB objects via some kind of DB objects registry. The multithreading DB access is protected at