On Aug 4, 2011, at 2:48 PM, Mark Erbaugh wrote: > Thanks again for the help. I decided to time the various approaches. My > original approach took 4:23 (minutes: seconds). Note: all my times included > data generation and insertion into a SQLite on-disk database. > > > > This took 3:36
17%... > This took 2:28 43%... > I did this with one session.execute for each table, rather than chunks. It > took 0:46 82% ! fairly nailed the last one at least >> The range of speedups here would be between 30% and 80%, with direct usage >> of connection/session .execute() with Table metadata giving you the 80%. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@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.
