Hi again, Just wanted to sum up. The solution that I was looking for was to operate on a detached state objects, without any transaction present (re-re-read the docs today). Now I just simply do:
1. fetch selected objects from database 2. Session.remove() (one could use expunge_all() instead to have transaction running - however would that make the transaction clean ? i.e. would then be any database level locking ?) 3. operate on objects 4. Session.add/add_all(object(s)) 5. Session.commit() This works quite well. I just wonder now, how expensive are session lookups (object in Session), or Session.add/expunge/remove/close calls ? I want to minimize any overhead. Seems that this is the only thing left for me to investigate currently ;) Thanks in advance. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
