5. Data Loading : Initial Data Load : Batch Inserts
 
Share this page                  
Batch Inserts
Vector supports batch statements through ODBC, JDBC, and .Net. Through the batch interface, inserts are internally transformed into efficient data appends. From a data storage perspective applying a large transaction that (among others) consists of many inserts into the same table is as efficient through the batch interface as it is through an intermediate staging step on the file system followed by a bulk load using vwload or the COPY statement.