-
Enhancement
-
Resolution: Unresolved
-
Major
-
None
-
None
-
False
-
-
False
-
-
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.
- relates to
-
DBZ-9449 Apply query.fetch.size universally to all non-snapshot data queries
-
- Open
-