I wasn't going to bother, but I had a look at doing this just out of curiosity, and these were the results:
executemany(): Inserting 424 entries: 0.3362s Inserting 20,000 segments: 14.01s COPY: Inserting 425 entries: 0.04s Inserting 20,000 segments: 0.3s So a pretty massive boost. Thanks :) On Monday, 24 March 2014 23:30:32 UTC+8, Jonathan Vanasco wrote: > > Since you're using Postgres... have you considered using python to > generate a COPY file ? > > Sqlalchemy doesn't seem to support it natively... maybe via 'text', but > your underlying psycopg2 driver does. > > it's way way way faster. i've found it significantly faster than dropping > fkeys and using prepared statements. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.