big cleanup - get rid of all the transaction-caching junk that was there before
fix groupby typo