What are the disadvantages of transaction in sql?


#1

What can be the situations where transaction may reduce performance


#2

When transaction has locked database , then other transaction may have to wait for a long time.