Re: Poor addBatch performance. Why dosn't it use copy ?

From: Kris Jurka <books(at)ejurka(dot)com>
To: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Poor addBatch performance. Why dosn't it use copy ?
Date: 2007-04-20 15:07:23
Message-ID: Pine.BSO.4.64.0704201105350.26355@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Bill Middleton 2007-04-20 20:00:47 PGXADataSource does not implement DataSource
Previous Message Kris Jurka 2007-04-20 15:05:23 Re: Poor addBatch performance. Why dosn't it use copy ?