Getting Started with Adobe After Effects - Part 6: Motion Blur
This module helps you to share, discuss and learn interview questions and answers of different technologies

What are the ways to code efficient transactions?

Dec 8 2012 12:00AM by Ankit Shah   

Question

What are the ways to code efficient transactions?

Answer

Some ways and guidelines to code efficient transactions:

  1. Do not ask for an input from a user during a transaction.
  2. Get all input needed for a transaction before starting the transaction.
  3. Transaction should be atomic
  4. Transactions should be as short and small as possible.
  5. Rollback a transaction if a user intervenes and re-starts the transaction.
  6. Transaction should involve a small amount of data as it needs to lock the number of rows involved.
  7. Avoid transactions while browsing through data.

Read More..   [32134 clicks]

Published under: DBA Interview Questions · SQL Server Interview Questions ·  ·  · 


Ankit Shah
298 · 0% · 147
2
 
0
Asked



Submit

Your Comment


Sign Up or Login to post a comment.

"What are the ways to code efficient transactions?" rated 5 out of 5 by 2 readers
What are the ways to code efficient transactions? , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]