客户端上传时没有调用批量程序？ [英] Bulk procedures not being called on client upload?

问题描述

抱歉，我还有另一个新手问题。我已在本地（SQL 2008）和Sql Azure服务器上配置了数据库。

Hi, sorry but I have another newbie question. I have provisioned a database both locally (SQL 2008) and on a Sql Azure server.

在配置我的范围时，我检查了启用批量过程框，并且可以看到'批量工件'已创建。

When provisioning my scope, I checked the enable bulk procedures box, and can see that the 'bulk artifacts' have been created.

但是，当我在客户端的上传请求中发送大量更新实体时，常规_update sps正在被解雇而不是_bulkupdate。 

However, when I send a large set of updated entities in an upload request from the client, the regular _update sps are being fired and not the _bulkupdate ones. 

因此，Azure Web角色/ Sql Azure数据库的速度特别慢 - （处理16,000的上传请求需要4分钟）行）

Because of this, it is especially slow with an Azure Web Role/Sql Azure database - (4 minutes to process the upload request for 16,000 rows)

相关表格包含动态过滤器参数，因此基于模板。 

The table in question has dynamic filter parameters and so is based on a template. 

我希望我的措辞（和事实）在这里是正确的，如果答案很明显，我会道歉，但我错过了什么？

I hope I have my wording (and facts) correct here, apologies if the answer is obvious, but am I missing something?

谢谢。

推荐答案

如果您遇到的话，可以检查您的ApplyChangeFailed事件吗？冲突？

can you check your ApplyChangeFailed events if you're running into conflicts?

您实际上甚至不必设置启用批量程序，因为它将自动为SQL 2008及更高版本启用。 

you don't actually even have to set enable bulk procedures, since it will automatically be enabled for SQL 2008 and above. 

这篇关于客户端上传时没有调用批量程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！