Bug hunting could be fun too. Have you tried giving yourself a prize every time you find or fix one?
add incremental aggregate statistics to the micropayment engine.
Tricky I guess, and totally out of my comfort zone because not sure what incremental aggregates refers too. Data? is the lag created because the time ranges are fixed to begin with? Or could it start from now() and go backward instead?
now()and go backward instead?