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

Apply query.fetch.size universally to all Oracle non-snapshot queries

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Unresolved
    • Icon: Major Major
    • 3.4.0.Alpha1
    • None
    • oracle-connector
    • None

      As discussed on Zulip https://debezium.zulipchat.com/#narrow/channel/302533-dev/topic/Query.20Fetch.20Sizes/near/537964965

      I've identified that when using the Oracle connector over a WAN connection, there are multiple queries that the connector executes that use the default fetch size of 1, and this leads to severe performance issues.

      For example, the call during the snapshot to getAllTableIds takes 55 seconds over a WAN connection without a fetch size set, but with a fetch size of 10k takes 1 second to return just over 2100 records.

      So lets reuse the query.fetch.size property as suggested and lets scope this change to apply just to the Oracle Connector.

              ccranfor@redhat.com Chris Cranford
              ccranfor@redhat.com Chris Cranford
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated: