JDBC Data Sources with "Use last run datetime" option unchecked

Impact area

Performance

Severity

Warning

Affected element

All

Rule ID

SN-0093

Impact

Repeatedly importing data that has not changed leads to many skipped rows and unnecessarily bounds system resources.

Remediation

Ensure that each import is not importing all records every time by using the "Use Last Run Datetime" option. If you are running a JDBC import, use the last run datetime option in your import set Data Source. For a type of File import, be sure that whatever is generating your files is only adding data that is new, or has been changed.

Time to fix

5 min




Last modified on Jun 10, 2020