Array interface

The LN MSQL database driver can use multi-row ODBC statements for array fetches and array inserts. With the array interface, communication between the MSQL driver and SQL Server is more efficient. Multiple rows can be fetched or inserted with a single ODBC call. Because multiple rows are stored in a buffer in the LN MSQL database driver, more memory is consumed. The array interface is especially useful when accessing a remote database, because it reduces the number of network round-trips and increases performance.

The array fetch interface is enabled by default and can be disabled with the resource variable msql_array_fetch:0. The array insert interface is also enabled by default and can be disabled with the resource variable msql_array_insert:0.

Array inserts are always enabled when loading data using the bdbpost utility.

During data loading using the bdbpost or bdbreconfig utility, the number of buffered records is specified by the table_load_array_size resource.