commit

Sets the transaction commit per this number of rows.

By default the rdm_dbImport () function performs the import of all rows in an import file in one transaction. If there is any failure during the import, the database will remain as it was prior to the import (no rows inserted). However, for a large import, the amount of memory resources consumed in the function can be quiet large, affecting performance or possibly causing an out of memory error.

The commit option allows the import to be broken up into smaller transactions to save on system resources needed for the import. For example:

commit=1000

The setting above in the optString argument will perform a tansaction commit after every 1000 rows are inserted into the database.

Note
If this option is used, any failure will rollback to the last successful transaction commit rather than to the beginning of the import start.