I received this question by email last week: Is it ever required to use more than one transaction per program? The simple answer is that you mostly only need one transaction active per command: you shouldn't leave a transaction active outside of a command, as this is likely to cause problems at some point, and […]