Database Networking

The Database Networking Configuration Editor contains networking and SQL parameters used when communicating with the CopyStorm database.

Parameter Name	Default Setting	Required	Description
Destination Batch Size	100	No	Limits the number of rows that will be written to the target database in a single batch. A smaller number minimizes memory requirements but increases run time. A larger value increases memory requirements and decreases run time.
DDL Timeout (seconds)	Blank	No	Set the number of seconds CopyStorm will wait for a DDL operation to complete. DDL operations, like CREATE INDEX, may take considerably longer than DML operations and thus have their own timeout parameter.
# Database Buffers	10	No	Sets the number of output buffers to use when running in multi-thread mode. A larger value increases memory requirements but allows Salesforce to read more records before they are written to the target database.
Rows Per Multi-Insert	Blank	No	If specified then multiple rows will be sent to the database in a single INSERT statement. Please note that not all databases support this feature and when the database is on a local network there is unlikely to be any performance gain by enabling this feature.
Enable CSV Bulk Import	Checked	No	If set and is supported by the database then CSV bulk imports will be used. For analytical databases like RedShift or Snowflake this option should almost always be selected.