Increasing Transaction Performance
Distributed transactions can become very complex, involving many data sources, and can consume valuable resources. You can create efficient transactions by keeping these guidelines in mind:
Don't begin a transaction and then prompt for input from a user during the transaction. If you begin a transaction, then prompt for input, the transaction will block other transactions from finishing and will consume resources. Even if the user reacts immediately to the input request, his response time is significantly slower than an uninterrupted transaction. Prompt for all necessary input from users before beginning a transaction.
Keep the transactions as short as possible. Do not open the transaction before it is required, ...
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
