generating reports takes minutes
Andrew Sackville-West
ajswest at mindspring.com
Wed Nov 1 13:47:02 EST 2006
On Wed, Nov 01, 2006 at 10:20:31AM -0800, John Clements wrote:
> >
> > I'm using gnucash with data that starts in 2002 - that is 4 years
> > of data...
> > Generating a report seems to take minutes - and I generate several at
> > startup - :(
> >
> > Is there a way to improve this "speed" ?
> > Report generation is becomming a pain, and I feel it's horribly slow
> > compared to M$ Money which only takes seconds ...
> >
>
> I've experienced this for years, and I recently noticed that it seems
> to be much slower for finer-grained time intervals. So let me ask a
> (possibly insulting) question. When I'm generating, say, a cash-flow
> report for N time slices (e.g. quarterly for 4 years = 16 slices),
> with a database of M transactions, is there an operation in there
> that's of time NM?
>
> For instance, I can just imagine this piece of code:
>
> (let ([divided (map (lambda (range) (filter (falls-in-range range)
> all-transactions))
> given-ranges)])
> ...)
>
> ... which would result in scanning the list of transactions N times.
> You can tell me the code isn't written this way, and I'll just keep
> my mouth shut and deal with it.
if you mean a custom multi-column report, then I think you are right
as each report that is included in that report is a seperate report in
itself. If you are talking about subtotalling in a report (like the
transaction report with its many combinations of sorts and subtotals)
then I don't know.
A
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.gnucash.org/pipermail/gnucash-user/attachments/20061101/2545cfd7/attachment.bin
More information about the gnucash-user
mailing list