commit

Set the commit per this number of rows.

The import prcocess 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 consummed on the RDM client could be quiet large affecting performance or possibly running the client out of memory.

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 COMMIT after 1000 inserts are performed into the target database.

Note

Any failure will rollback to the last successful COMMIT and not to the beginning of the import start.