Your application is handling long-running transactions that sometimes time out, causing data integrity issues. How would you manage and optimize these transactions?