don't make a table called Transactions that everything needs to go through to balance. It will create a bottleneck that slows _everything_ down (I'm looking at you Axapta/Dynamics AX - at least older versions, dunno if they ever fixed it).