Choosing between CDC and polling
Change data capture is not always the answer. When polling is fine, when it is not, and how to tell.
Tom Okafor
Head of Product
8 min
Change data capture reads the database log. Polling asks the database what changed. Both work, and both have a cost.
Use CDC when
You need deletes, not just inserts and updates
Tables are large and change often
You cannot add an updated_at column everywhere
Polling is fine when
Tables are small or append only
You only have read replica access
A few minutes of lag is acceptable
Sluice supports both on the same connector, so you can start with polling and switch a table to CDC later without a resync.