List few ways to code transactions in an efficient manner?

devquora
devquora

Posted On: Feb 22, 2018

 

It is imperative that transactions are kept as short as possible. It should be short in order to reduce contention for resources. The following are few guidelines for coding transactions efficiently –
  • It doesn’t require input from users during transactions.
  • Transactions must not be opened while browsing through data.
  • Make use of lower transaction levels.
  • While transacting, least information of data must be accessed.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    DBMS Interview Questions

    What is DBMS?

    DBMS (Database Management System) is a computer software application that allows users and other applications to view,..

    DBMS Interview Questions

    Enlist various types of interactions created by DBMS ?

    There are various kinds of interactions supported by DBMS like- Data definition Update Retrieval Administration..

    DBMS Interview Questions

    What are the features of Database language?

    Database language is used to create and store data in computer system. DBMS itself is one of the features of database l..