User`s guide

7 Functions — Alphabetical List

7-170

More About

Tips

• When working with a JDBC driver connection or a JDBC/ODBC bridge connection

established using database, fastinsert offers improved performance over insert.

insert creates and executes an SQL insert query for each row of data. fastinsert

creates the insert query only once and then allows for the data values to be plugged

in. All rows of data get inserted as a batch resulting in an overall faster performance

over insert. However, since fastinsert relies more on driver functions compared

to insert, it is possible in some edge case scenarios that the driver functions do not

work as expected. In such cases, use insert especially if the data to insert is small.

datainsert is faster than fastinsert but needs data to be formatted in a specific

way and accepts cell arrays and numeric matrices as input data.

• When working with a native ODBC connection established using the

database.ODBCConnection function, fastinsert and insert are identical.

datainsert is not supported for native ODBC connections.

• insert uses the same syntax as fastinsert.

• “Connecting to a Database Using the Native ODBC Interface”