Re: JDBC addBatch more efficient? - Mailing list pgsql-general

From David Wall
Subject Re: JDBC addBatch more efficient?
Date
Msg-id 480CACEF.7000208@computer.org
Whole thread Raw
In response to Re: JDBC addBatch more efficient?  (Kris Jurka <books@ejurka.com>)
List pgsql-general
> The JDBC driver's batch processing is more efficient than regular
> execution because it requires fewer network roundtrips so there's less
> waiting.  The JDBC batch is broken into an internal batch size of 256
> statement and all of these are sent over to the server at once.

That's great, Kris.  I  believe our code only does 100 updates/deletes
before committing the transaction anyway, so this should work well for us.

Thanks,
David

pgsql-general by date:

Previous
From: zedware
Date:
Subject: Re: How to tell if 64 bit vs 32 bit engine?
Next
From: Ivano Luberti
Date:
Subject: Re: JDBC addBatch more efficient?