Re: Income statement performance (was Re: Reading whole db at startup))

2008-12-08 Thread Andrew Sackville-West
On Fri, Nov 21, 2008 at 12:19:11PM -0500, Phil Longstaff wrote: BTW, when I was testing this, I had a printf() telling me each time a split query was done for an account. When I ran an income statement, it queried each expense and income account twice, then repeated that, so that each

Income statement performance (was Re: Reading whole db at startup))

2008-11-21 Thread Phil Longstaff
On November 21, 2008 11:39:33 am Phil Longstaff wrote: OK. I have modified code (not committed yet) which doesn't read tx/splits at startup. At startup, it executes: SELECT account_guid, reconcile_state, sum(quantity_num) AS quantity_num, quantity_denom FROM splits GROUP BY account_guid,