Re: slow speeds after 2 million rows inserted

[Guy Rouillier <guyr-ml1(at)burntmail(dot)com>]

Frank Finner wrote:
> In Java, assuming you have a Connection c, you simply say
> "c.commit();" after doing some action on the database. After every
> commit, the transaction will be executed and closed and a new one
> opened, which runs until the next commit.

Assuming, of course, you started with c.setAutoCommit(false);

--
Guy Rouillier