Uploaded image for project: 'Debezium'
  1. Debezium
  2. DBZ-1124

Consider change tracking as an optimization to CDC queries

    XMLWordPrintable

Details

    • Task
    • Resolution: Unresolved
    • Major
    • None
    • None
    • sqlserver-connector
    • None

    Description

      SQL Server provides a change tacking that should allow us to get infoirmation which changes has changed and thus query only change tables of modified tables. Before more detailed work we need to

      • verify if CDC and CT can be both enabled in parallel
      • Can we use it when snapshot isolation is not available?

        To overcome the previously listed challenges, we recommend that you use snapshot isolation. This will help to ensure consistency of change information and avoid race conditions that are related to the background cleanup task. If you do not use snapshot transactions, developing an application that uses change tracking could require significantly more effort.

      • Is it really an optimization? Does not it query all chnage tables internally?
      • Is there a conversion/relation between LSN and synchrnization version?

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jpechane Jiri Pechanec
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: