Re: JDBC batching

Tony,

The batch API works in one round trip in 7.2.

thanks,
--Barry

Tony DeWitt wrote:

> I have looked through all the documentation that I can find, as well as the
> mailing list archives, and I haven't been able to find the answer to this.
> I'm currently running pgsql 7.0.2.
>
> What I'm trying to do is make a large number of writes to a single table in
> an efficient way. Currently our code makes a separate request for each
> INSERT statement, incurring too many round trips.
>
> I want to convert this to the batch interface, i.e., addBatch() and
> executeBatch(), but I read that this is implemented as multiple round trips
> anyway in 7.1.x and before. I also read that this might be fixed in 7.2, but
> I've been unable to verify this in the documentation.
>
> Can anyone enlighten me on the state of the batching interface? or is there
> some better way to do this?
>
>
> Thank you,
> Tony DeWitt
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>