使用 Windows Workflow 进行批处理
任何人都可以提供使用 Windows 工作流处理批次信息的任何链接和/或建议吗？
具体来说，我正在研究一个发票场景，其中生成价格需要复杂的规则，并且我希望能够从 SQL Server 2008 数据库读取超过 50k 行的数据，并通过工作流程处理这些数据以生成每行的价格然后将被写回数据库（针对每行）。在定价过程中，工作流程还需要从数据库中查找其他信息。工作流程本身已经定义并正在运行，因为在创建作业时也使用它来提供作业的初始估计。
我现在还想指出，我已经知道通过存储过程进行处理会明显更快，但我正在考虑可维护性和速度的选项。也就是说，欢迎所有评论。
我目前正在使用 .NET 3.5 中的工作流，但我也有兴趣知道工作流/.NET4 是否有任何增强功能可以提高上述场景中的性能。
谢谢。
Can anybody please provide any links and/or recommendations for the processing of batch information with Windows Workflow.
Specifically, I am looking at an invoicing scenario where there are complex rules required for the generation of prices and I am looking to be able to read in excess of 50k rows of data from a SQL Server 2008 database and process these through a workflow to generate a price for each row which will then be written back to the database (against each row). The workflow will also need to lookup additional information from the database during the pricing process. The workflow itself is already defined and working as it is also used when a job is created to provide the initial estimate for the job.
I would also like to point out at this time that I already know processing through a stored procedure will be significantly faster, but I am looking at options for maintainability as well as speed. That said, all comments are welcome.
I am currently working with workflows in .NET 3.5, but I would also be interested to know if there are any enhancements coming with workflow/.NET4 that would improve performance in the scenario outlined above.
Thanks.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论