我在ADF中使用存储过程活动进行转换。这项工作非常缓慢。有什么选择吗？ [英] I'm using Stored Procedure Activity in ADF for transformations. The working of that is very slow. Is there any option?

问题描述

我在ADF中使用存储过程活动进行转换。这项工作非常缓慢。我听说我们也可以用Python做到这一点。我们可以这样做吗？如果是，请解释我们如何做到这一点。并帮助我哪个更快的python或存储过程
活动？

I'm using Stored Procedure Activity in ADF for transformations. The working of that is very slow. I heard we can also do that with Python. Can we do that ? If yes, please explain how can we do that. And help me which is the faster python or Stored Procedure Activity?

推荐答案

你好Vijay Narra并感谢您的询问。

Hello Vijay Narra and thank you for your inquiry.

存储过程活动是在SQL服务器上运行的计算操作。 您的服务器越快，活动应该花费的时间就越少。  Python是一种语言，必须在某些东西上运行。

Stored Procedure Activity is a compute action run on your SQL server.  The faster your server, the less time the activity should take.  Python is a language, and must be run on something.

还有其他计算选项。 对于所有这些数据，必须将数据从源（我假设您的SQL服务器）移动到计算资源，然后将结果存储在某处（我假设您的SQL服务器，因为您正在使用存储过程）。

There are other compute options.  For all of them, the data must be moved from your source (I assume your SQL server) to the compute resource, and then the results stored somewhere (I assume your SQL server because you are using stored procedure).

每个选项的速度是资源启动时间，数据传输时间和处理时间的组合。 选择使用哪个选项取决于您。 一些服务需要更长时间才能启动，但功能更强大。 其他人总是在开，但有其他
限制。

The speed of each option is a combination of resource spin-up time, data transfer time, and processing time.  Which option to use is up to you.  Some services take longer to spin-up, but are more powerful.  Others are always-on, but have other limitations.

哪一个适合你取决于你的使用案例。

Which one is right for you depends upon your use case.

如果您想了解更多建议，请提供详细信息。

If you would like more advice, please provide details.

这篇关于我在ADF中使用存储过程活动进行转换。这项工作非常缓慢。有什么选择吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！