-
Notifications
You must be signed in to change notification settings - Fork 126
Description
Problem
The Oracle driver currently lacks the functionality to provide sync progress statistics, such as an Estimated Time of Completion. This creates an inconsistent user experience compared to other drivers (e.g., MySQL, Postgres) where these stats are available.
Root Cause
The core issue is that the Oracle driver does not determine the total number of records to be synced before the process begins. As seen in the oracle/backfill.go
, other drivers execute a query to get an approximate row count from the table's metadata and pass this value to the AddRecordsToSyncStats
function.
Proposed Solution
We need to implement logic to query Oracle's data dictionary to get an estimated row count for the table being synced. Also, it needs to be near to accurate, so that it doesn't output wrong information.
For reference, Postgres and mysql driver's backfill code can be viewed.