it will ensure that multiple queries produce the result consistent to the one point in time, but that transaction will not modify tables, so it doesn't have to put exclusive lock on them.
oracle has that in "set transaction read only" -- you don't have to wonder where i got it ;) useful for reports and stuff like that, where everything should 'fall in their place'. as i said, this could easily be just plain stupid in ORM. please don't get me wrong, i'm not asking for a feature, just putting in extra idea while you still drafting. On 04/09/06, Michael Bayer <[EMAIL PROTECTED]> wrote: > > On Sep 4, 2006, at 11:32 AM, Andrija Zaric wrote: > > > - will 'read' mean serializabile isolation level (like Hibernate docs > > imply), or "read-only" (all reads during a transaction will produce > > the same result)? If the former, maybe 'read_only' can be added as a > > feature of transaction? > > how would "read-only" work exactly ? im not sure if i understand > what it does. > ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users