[send post, since the first one was rejected by MTA]
Il giorno ven, 20/04/2007 alle 04.39 -0700, femski ha scritto:
> Why doesn't the Postgres JDBC driver use "copy" for faster bulk insert ?
> What is the best way to speedup
> do bulk insert at this time or in near future (I was to use standard JDBC
> API) ?
I use addBatch() very often when, but I use it with statement that work
on different tables. I think it would really be difficult to check if
the statements are referring the same table and the same field.
Why don't you write all record in one insert statement like "INSERT INTO
table (fields) VALUES (...,...), (...,...), (...,..);" I think both
oracle and postgres 8.2 should accept this syntax.
In response to
pgsql-jdbc by date
|Next:||From: Ido M. Tamir||Date: 2007-04-20 14:02:32|
|Subject: Re: Poor addBatch performance. Why dosn't it use copy ?|
|Previous:||From: femski||Date: 2007-04-20 11:39:37|
|Subject: Poor addBatch performance. Why dosn't it use copy ?|