EF6，缓慢的Azure Sql写入，TransactionHandler [英] EF6, Slow Azure Sql Writes, TransactionHandler

问题描述

如果其他人遇到相同的问题，我会发布此信息.我们实现了EF6 TransactionHandler，该功能旨在帮助解决Sql Azure上的瞬时错误.

I am posting this in case anyone else runs into the same problem. We implemented the EF6 TransactionHandler which is suppose to help transient errors on Sql Azure.

https://msdn.microsoft. com/en-us/library/dn630221(v = vs.113).aspx

我们没有意识到桌子没有被清理干净.最终__transactionHistory表具有数千条记录.每次我们写SQL时，由于这种机制，都会造成5-10秒的可怕延迟.

We didn't realize the table does not get cleaned. Eventually the __transactionHistory table had thousands of records. Every time we wrote to SQL, because of this mechanism, it caused horrible 5-10 second delays.

此修复程序，我们将其删除.来自MS的实施应已自动清除了该表.我们的没有.

The fix, we removed it. The implementation from MS should have auto cleaned that table. Ours did not.

Ef6 Azure Sql写入缓慢

Ef6 Azure Sql slow writes

推荐答案

这并不是真正的问题，我只是想发布一些有关它的信息，以防其他人搜索EF6 Azure Sql Performance.

This wasn't really a question, I just wanted to post something about it in case others search for EF6 Azure Sql Performance.

这篇关于EF6，缓慢的Azure Sql写入，TransactionHandler的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！