Re: Poor addBatch performance. Why dosn't it use copy ? - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Poor addBatch performance. Why dosn't it use copy ?
Date
Msg-id Pine.BSO.4.64.0704201105350.26355@leary.csoft.net
Whole thread Raw
In response to Re: Poor addBatch performance. Why dosn't it use copy ?  (Giuseppe Sacco <giuseppe@eppesuigoccas.homedns.org>)
List pgsql-jdbc

On Fri, 20 Apr 2007, Giuseppe Sacco wrote:

> 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.

Well Statement.addBatch and PreparedStatement.addBatch are different
beasts.  It wouldn't be worth it to try and parse each Statement, but
parsing the PreparedStatement would be possible.

Kris Jurka

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: Poor addBatch performance. Why dosn't it use copy ?
Next
From: "Bill Middleton"
Date:
Subject: PGXADataSource does not implement DataSource