The longer the transaction, the longer the exclusive or update locks are held, blocking other activity and leading to possible deadlock situations.

• 事务的运行时间越长,它持有排他锁或更新锁的时间也就越长,从而会阻塞其他活动并可能导致死锁。