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 [email protected]. > To unsubscribe from this group, send email to > [email protected]. > 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
