[sqlalchemy] Re: sqlalchemy connection pooling and mysql last_insert_id()

2008-07-11 Thread Henk
As far as I know SqlAlchemy does not use LAST_INSERT_ID() (at least not for single row inserts), At the mysql protocol level, the id created for the auto inc column will be returned for each insert statement (as the result code for that command). The python MySQLdb dbapi driver will make this

[sqlalchemy] SA Performance (some profiling on simple selects)

2008-07-11 Thread Henk
Hi I did some profiling a simple select type query to check SA performance for such use-cases The test consiste of a very simple Order record: order = Table('tblorder', metadata, Column('order_id', Integer, primary_key = True), Column('order_user_id', Integer),

[sqlalchemy] Re: ResultProxy does not autoclose

2008-07-04 Thread Henk
because it is not a subclass of dbapi.Error... If fixed my dbapi module, now it works, thanx. On Jul 4, 3:50 pm, Michael Bayer [EMAIL PROTECTED] wrote: On Jul 4, 2008, at 4:52 AM, Henk wrote: Hi, I notice that the ResultProxy class has no __del__ method. I am using the sql