Yesterday I downloaded 0.6beta3 and it took 27 seconds against 41 on 0.5. Pretty good results.
2010/4/10 Michael Bayer <mike...@zzzcomputing.com>: > nekto0n wrote: >> 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? > > whats funny there is that the kinterbasdb is marked as not even supporting > proper rowcount. the ORM shouldn't be calling it. Have you tried 0.6 ? > > > >> >> 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. >> >> > > -- > 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. > > -- 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.
