title: side effects of using transactions of PDO
body: <p>I have recently switched to PDO, and I have read about transactions, but after some readings, I am still confused about some aspects of using transactions.</p>
  
  <ol>
  <li>I have read that Long-Running Transactions causes a lock, so how to prevent this?</li>
  <li>are there any other problems (apart from Long-Running Transactions)  which might occur when using transactions and how we can tackle them?</li>
  </ol>
  
  <p>Thanks in advance </p>