3.30在ASP.NET中使用Transaction的几点注意

TIP:Transaction使用原则,只在程序需要的时候使用.例如:如果是简单的从数据库取数据,或者简单的查询,你就不需要使用transaction,另一方面,如果你是在几个相关联的表中插入数据,你就需要使用事务.一般来讲,我们不会为一个简单的操作使用事务:比如Update,DELETE或者Insert.

Even though ADO.NET provides good support for transactions, you should not always use transactions. In fact, every time you use any kind of transaction, you automatically incur some overhead. Also, transactions involve some kind of locking of table rows. Thus, unnecessarily using transactions may harm the overall scalability of your application.When implementing a transaction, you can follow these practices to achieve the best results:
• Keep transactions as short as possible.
• Avoid returning data with a SELECT query in the middle of a transaction. Ideally, you should return the data before the transaction starts.
• If you do retrieve records, fetch only the rows that are required so as to not lock too many resources and so as to keep performance as good as possible.
• Wherever possible, write transactions within stored procedures instead of using ADO.NET transactions.
• Avoid transactions that combine multiple independent batches of work. Put separate batches into separate transactions.
• Avoid updates that affect a large range of records if at all possible.