side effects of using transactions of PDO
<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>