Hi there! I'm now in the process of migrating from pure kinterbasdb to SQLAlchemy. Everything is fine except for speed of insertions and maybe updates. After some time of profiling I found out that a significant amount of time is spent on getting "rowcount" after execution. It takes about 5 seconds vs 41 spent on 3000 insertions themselves. That is 12%. Not much, but still. Digging further showed that rowcount attribute of kinterbasdb.Cursor is a getter, which remotely calles to Firebird Database. Here is the comment from _kicore_cursor.c source file: "Determining rowcount is a fairly expensive operation that requires an isc_dsql_sql_info call". I wonder if there's any possible way to make getting "rowcount" optional or lazy?
Thanks! -- 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.
