What belongs in one database transaction?

Keep the reads and writes that must succeed together in one transaction. For example, moving inventory between two locations should not leave the first location decremented if the second update fails. Set the boundary around the invariant, not just around a convenient batch of queries.