I came across a few other features in the SQLAlchemy manual. Query.delete() and Query.update() do bulk deletes and updates. However, I don't quite understand the explanation, so I'm not sure if they can replace all SQL deletes & updates at the same speed. It also looks like you should expire all ORM objects after doing a bulk update/delete, in case the database has changed out from under them.
http://www.sqlalchemy.org/docs/reference/orm/query.html Search for "delete" and "update" methods. SQLALchemy 0.6 adds a ".returning" method, which makes it easier to access stored procedures. However, it has different restrictions for each database type. It also makes some changes to the aforementioned Query.delete and Query.update. 0.6 is currently in beta 1, and the manual is for beta 2. http://www.sqlalchemy.org/trac/wiki/06Migration See "8. RETURNING support" and "10.1. Changes to query.update() and query.delete()" -- Mike Orr <[email protected]> -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en.
