On Sun, 20 Apr 2008, David Wall wrote:
> Just checking if the JDBC library's batch processing code is more efficient
> with respect to the postgresql back end or not. Does it really batch the
> requests and submit them once over the link, or does it just send them to the
> database to be processed one at a time?
>
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.
Kris Jurka