Database Optimization

The Database Query Optimization Parameter Editor controls optimizations used when generating SQL queries for the CopyStorm database.

Parameter Name	Default Setting	Description
Optimize Insert SQL	Unchecked	If checked, CopyStorm will not include NULL data in generated INSERT statements. For wide tables with many NULL values this may be considerably faster than unoptimized INSERT statements.
Optimize Update SQL	Checked	If checked, CopyStorm will compare data from Salesforce with existing data in the CopyStorm database and build minimal SQL UPDATE statements. For wide tables with few changes this may be considerably faster than unoptimized UPDATE statements.
Optimize Timestamps	Checked	If checked, then use the time of the most recently complete CopyStorm job to reduce the number of records read from Salesforce. If not checked, then the timestamp of the newest record in Salesforce is used to build SOQL queries, and at least one record from each table will always be read.
Force Updates	Unchecked	If checked, CopyStorm will write all records read from Salesforce to the target database. Records will be updated even if the timestamp is the same as the Salesforce timestamp. This option can be used in conjunction with the “Modified Since” and “Modified Thru” parameters to force CopyStorm to re-read records from Salesforce and update any fields that are out of sync.
Optimize Deleted Record Scan	Checked	If checked then CopyStorm will use information from the previous backup to minimize the number of records scanned when searching for deleted records. This option is ignored if the Delete Older Than option is blank.
Update Using DELETE/INSERT	Unchecked	If checked then CopyStorm will UPDATE records by first deleting them and the re-inserting them. This option is ignored if the Optimize Update SQL option is checked.
Optimize Update Classification	Checked	If checked, CopyStorm will try to avoid database queries used for deciding if records are inserts or updates. If this parameter is unchecked, CopyStorm will always query the database to decide if a record should be inserted or if a pre-existing record should be updated in the database. For example, if a table is empty when CopyStorm starts to copy data, then there is no reason to look for updates - all records will always be inserts.
Optimize Snapshot Purge	Checked	When checked, Snapshot record cleanup will happen after all records are copied from Salesforce. When unchecked, Snapshot records will be cleaned up after each object is replicated.