UseIncrementalStatements
The UseIncrementalStatements
parameter specifies whether to run queries that identify new/updated and deleted records.
- When
UseIncrementalStatements=False
, the connector performs a full synchronize every time the task runs, using the query specified by the SQL parameter. -
When
UseIncrementalStatements=True
, the connector only performs a full synchronize the first time the synchronize task runs:- The first synchronize cycle runs the query specified by the InitialStatement parameter. If this parameter is not set, the connector runs the query specified by AddedAndUpdatedStatement.
- The following synchronize cycles run the query specified by AddedAndUpdatedStatement to retrieve added and updated documents, and the query specified by DeletedStatement to retrieve deleted documents.
Using incremental mode can be more efficient if the database has items stored by modified date, because the connector doesn't need to rescan the entire database.
Type: | Boolean |
Default: | False |
Required: | No |
Configuration Section: | TaskName or FetchTasks |
Example: | UseIncrementalStatements=True
|
See Also: |