Thread: Batch updates and inserts

On Mon, 9 May 2005, Igor Postelnik wrote:

> What combination of JDBC driver and backend do I need to have support
> for addBatch/executeBatch? What's a reasonable limit for number of
> statements in a batch - either by number of rows or total size?
>

Batch statements have been available in the driver for some time, but the
8.0 driver is the first driver to actually perform them in a batch
fashion.  It requires at least a 7.4 server to take advantage of this.
Size doesn't really matter because the driver itself will internally run
things in batches of 256 statements at a time.

Kris Jurka