且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

复制活动在一定容量以上存在性能问题,并且还将记录多次写入到接收器中

更新时间:2023-02-04 20:12:30

TexasJAPatterson,

我认为开始寻找的好地方是"writeBatchSize"参数.

有关更多信息,可以查看文档:

https://docs.microsoft.com/zh-cn/azure/data-factory/connector-odbc

文档中有一条说明:

对于"writeBatchSize",如果未设置(自动检测),则复制活动会首先检测驱动程序是否支持批处理操作,如果支持则将其设置为10000,否则将其设置为1.如果您显式设置的值不是0,则复制活动 如果驱动程序不支持批处理操作,则会接受该值并在运行时失败.

请告诉我们是否有帮助,否则我们可以继续进行对话.
Hi TexasJAPatterson,

I think a good place to start looking would be the "writeBatchSize" parameter.

For more information, you can check the documentation :

https://docs.microsoft.com/en-us/azure/data-factory/connector-odbc

There's a note in the documentation that says :

For "writeBatchSize", if it's not set (auto-detected), copy activity first detects whether the driver supports batch operations, and set it to 10000 if it does, or set it to 1 if it doesn’t. If you explicitly set the value other than 0, copy activity honors the value and fails at runtime if the driver doesn’t support batch operations.

Please let us know if this helps or else we can gladly continue the dialogue.