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

[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 
> account was queried 4 times.  I know someone was looking at report performance 
> earlier.  Might there be more opportunies to improve performance by cutting 
> out duplicate queries?  Of course, for a report, adding a mechanism to 
> calculate values in the db engine would be even better, but this is off in the 
> future.

I did some of that... interesting. I'll see if I can get back into
that. I *thought* I had removed all duplicate queries and cached all
the values. It's been a while though. I'll take a look at this shortly.

A
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 197 bytes
Desc: Digital signature
Url : http://lists.gnucash.org/pipermail/gnucash-devel/attachments/20081208/9505723e/attachment.bin