Michael On Mar 25, 1:50 pm, "Michael Bayer" <mike...@zzzcomputing.com> wrote: > SQLA uses the DBAPI in its default mode of "autocommit=False" and is always > going to issue flushes followed by a COMMIT or ROLLBACK. There's also a > ROLLBACK which occurs automatically via the connection pool and you can turn > that one off with a connection pool flag. But these operations are > practically free with MyISAM so there's no overhead consideration.
Thank you for the informative explanation. However, BEGIN/COMMIT/ ROLLBACK are absolutely not free in my case. I'm dealing with significant network latency because the database server is on another continent and also the server itself is beleaguered. It is very expensive to touch the database at all, even for what amounts to a "no- op". I want to turn off the issuing of transaction statements. I am able to do so with other database abstraction layer software. Thank you for all your help, Keith -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.
