This is all a great unearthing of the Mystery of Transactions. Thanks for the investigation, Doug.
This was difficult for me to learn when I got into web2py as well. Perhaps we could write up all this knowledge somewhere, now that you're figuring it out? Can we have a section on Transactions in the book, or somewhere?