NumberOfRowsPerBatch (GuttenBase - The database copying and migration framework 2.1.0 API)

```
public interface NumberOfRowsPerBatch
```
How many rows will be inserted in single transaction? This is an important performance issue.
We support two ways to insert multiple rows in one batch: Either with the PreparedStatement.addBatch() method or with multiple VALUES() clauses for an INSERT statement. The latter method is much faster in most cases, but not all databases support this, so the value must be 1 then.
The value also must not be too high so data buffers are not exceeded, especially when the table contains BLOBs.
© 2012-2034 akquinet tech@spree

Author:

M. Dahm

See Also:

MaxNumberOfDataItems

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method	Description
`int`	`getNumberOfRowsPerBatch(TableMetaData targetTableMetaData)`
`boolean`	`useMultipleValuesClauses(TableMetaData targetTableMetaData)`	Use VALUES() clauses or `PreparedStatement.addBatch()` as discussed above

Method Detail

getNumberOfRowsPerBatch

int getNumberOfRowsPerBatch(TableMetaData targetTableMetaData)

useMultipleValuesClauses
```
boolean useMultipleValuesClauses(TableMetaData targetTableMetaData)
```
Use VALUES() clauses or PreparedStatement.addBatch() as discussed above