Multi Row Insert

The ability to insert multiple database rows in a single SQL insert statement. The ANSI syntax for multi row is shown in the following table.

Single Row Inserts Multi Row Insert

Table 1. Comparing single row and multi row insert syntax
Single Row Inserts	Multi Row Insert
`INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3) INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3) INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3)`	`INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3), (val1, val2, val3), (val1, val2, val3)`

INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3)
INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3)
INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3)

INSERT INTO mytable (col1, col2, col3) VALUES (val1, val2, val3), 
                                              (val1, val2, val3), 
                                              (val1, val2, val3)

The FTM Persistence API supports multi row inserts as well as providing the following benefits:

Abstraction from database specific syntax
Configurable control of the rows per insert
Configurable control of the number of rows to cache in memory
Ability to insert using the 'insertable' views
Ability to insert direct to the tables
Full FTM instrumentation of all SQL issued through the API
Trace of SQL errors including SQL state and error codes