5.17Incremental synchronization

Naive approach:

every night:
query ALL 2 million Accounts

Better:

last successful sync:
2026-08-06 02:00

next query:
records changed after that

Conceptually:

SELECT ...
FROM Account
WHERE LastModifiedDate > :lastSuccessfulSync

Then:

store new high-water mark

This is often called:

watermark
high-water mark
incremental sync
delta load

Great integration vocabulary.