[sqlalchemy] rollbacks on select

Hello, I use the default options to run queries via sql expressions and I've noticed that SQLAlchemy does a rollback after every select using the mysql default engine. These rollback are not really useful and eat 15% of the CPU time. Is this a normal behavior, part of the auto commit custom

Re: [sqlalchemy] rollbacks on select

Sent from my iPhone On Aug 23, 2010, at 8:29 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: Hello, I use the default options to run queries via sql expressions and I've noticed that SQLAlchemy does a rollback after every select using the mysql default engine. These rollback are not really

Re: [sqlalchemy] rollbacks on select

On Mon, Aug 23, 2010 at 5:48 PM, Michael Bayer mike...@zzzcomputing.com wrote: Sent from my iPhone On Aug 23, 2010, at 8:29 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: Hello, I use the default options to run queries via sql expressions and I've noticed that SQLAlchemy does a rollback

Re: [sqlalchemy] rollbacks on select

On Mon, Aug 23, 2010 at 5:53 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: On Mon, Aug 23, 2010 at 5:48 PM, Michael Bayer mike...@zzzcomputing.com wrote: Sent from my iPhone On Aug 23, 2010, at 8:29 PM, Tarek Ziadé ziade.ta...@gmail.com wrote: Hello, I use the default options to run