Optimizing Data Access and Messaging
http://channel9.msdn.com/learn/courses/Azure/SQLAzure/SQLAzureTipsAndTricks/Exercise-3-Managing-Connections--Throttling-latency-and-transactions When working against a SQL Azure database you should be aware of the effects of Throttling , L
http://channel9.msdn.com/learn/courses/Azure/SQLAzure/SQLAzureTipsAndTricks/Exercise-3-Managing-Connections--Throttling-latency-and-transactions
When working against a SQL Azure database you should be aware of the effects of Throttling, Latency and Transactions.
Throttling, where SQL Azure automatically restricts new (or drops existing) connections, can occur when your database (or server hosting your database) is under heavy load. This ensures you server and database are protected from large numbers of connections and undo load.
However, it does mean you need to write your applications to handle a connection to dropping or transactions failing.
There are not any SQL Azure specific techniques for addressing these issues. In fact, addressing these issues is no different from handling them in the applications you build against on-premise databases.
Some common techniques include,
- Hold a connection open for as short a time as possible.
- Before issuing a command against a connection check it is still open, re-open it if SQL Azure has closed it. You may decide to implement a queue or other retry mechanism.
- Ensure you wrap all database calls in transactions – all exceptions (including ones thrown due to Throttling) should result in the transaction being rolled back.
上一篇: mysql 常用命令学习
下一篇: php的urlencode有关问题
推荐阅读
-
DAO(Data Access Object Pattern)
-
[EntLib]微软企业库6 基于Data Access Application Block的Repos
-
Optimizing Data Access and Messaging
-
Enterprise Library2.0(1):Data Access Application Block学
-
Tutorial for migrating data from MS Access to MySQ
-
论基于数据访问的集合类(Data Access Based Collection)和领域
-
Data Access FAQ (二)
-
Tutorial for migrating data from MS Access to MySQ_PHP教程
-
微软发布的Data Access Application Block的使用代码
-
MAVEN报错Cannot access alimaven / idea data注解不好使