• Home
• de.akquinet.jbosscc.guttenbase
• GuttenBase
• 2.1.0
• source code
• NumberOfRowsPerBatch.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

de.akquinet.jbosscc.guttenbase.tools.NumberOfRowsPerBatch Maven / Gradle / Ivy

package de.akquinet.jbosscc.guttenbase.tools;

import de.akquinet.jbosscc.guttenbase.meta.TableMetaData;

import java.sql.PreparedStatement;

/**
 * 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 {@link 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 MaxNumberOfDataItems
 */

public interface NumberOfRowsPerBatch {
  int getNumberOfRowsPerBatch(TableMetaData targetTableMetaData);

  /**
   * Use VALUES() clauses or {@link PreparedStatement#addBatch()} as discussed above
   */
  boolean useMultipleValuesClauses(TableMetaData targetTableMetaData);
}