search

eggnet / scm2pgsql

2 stars 2 forks source link

Use the jdbc batch inserts to improve speed #9

Closed bradens closed 12 years ago

schadr commented 12 years ago

sounds like a good idea, you can also form your insert queries in a way that they are properly concatenated in the case of

insert into some_table values (a1,b1), (a2,b2), ... ,(an,bn);

On Tue, May 8, 2012 at 1:36 PM, Braden Simpson reply@reply.github.com wrote:

Reply to this email directly or view it on GitHub: https://github.com/eggnet/scm2pgsql/issues/9

bradens commented 12 years ago

JDBC converts batch inserts into that form. Now the agilefant repo imports in <5 minutes.

schadr commented 12 years ago

sweet!

On Tue, May 8, 2012 at 2:11 PM, Braden Simpson reply@reply.github.com wrote:

JDBC converts batch inserts into that form.  Now the agilefant repo imports in <5 minutes.

Reply to this email directly or view it on GitHub: https://github.com/eggnet/scm2pgsql/issues/9#issuecomment-5586565