generating reports takes minutes

[Andrew Sackville-West]

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