Package de.akquinet.jbosscc.guttenbase.hints

Class NumberOfRowsPerBatchHint

java.lang.Object

de.akquinet.jbosscc.guttenbase.hints.NumberOfRowsPerBatchHint

All Implemented Interfaces:

ConnectorHint<NumberOfRowsPerBatch>

Direct Known Subclasses:

DefaultNumberOfRowsPerBatchHint, DisableMultipleNumberOfRowsPerBatchHint

public abstract class NumberOfRowsPerBatchHint
extends Object
implements ConnectorHint<NumberOfRowsPerBatch>

How many rows will be inserted in single transaction? This is an important performance issue.

We prefer to use use multiple VALUES() clauses for an INSERT statement in order to insert many rows in one batch. This is much faster in most cases than using PreparedStatement.addBatch(). Unfortunately, not all databases support multiple VALUES() clauses, so the value must be 1 then.

The value also must not be too high so that data buffers are not exceeded.

© 2012-2034 akquinet tech@spree

Hint is used by AbstractTableCopyTool to determine number of VALUES clauses in INSERT statement or statements in batch update

Author:

M. Dahm

Constructor Summary

Constructors

Constructor	Description
NumberOfRowsPerBatchHint()

Method Summary

Modifier and Type	Method	Description
Class<NumberOfRowsPerBatch>	getConnectorHintType()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface de.akquinet.jbosscc.guttenbase.hints.ConnectorHint

getValue

Constructor Detail

NumberOfRowsPerBatchHint

public NumberOfRowsPerBatchHint()

Method Detail

getConnectorHintType

public final Class<NumberOfRowsPerBatch> getConnectorHintType()

Specified by:

getConnectorHintType in interface ConnectorHint<NumberOfRowsPerBatch>