Reducing File Size
sunfish62 at yahoo.com
Tue Jan 4 15:03:13 EST 2011
I thank you for your willingness to take on this crucial part of the Gnucash realm. I'm not entirely sure what you're meaning by the reference to "external reporting", but I sincerely hope that you'll be successful with eguile, as I don't plan at this time to migrate over to the sql back end.
--- On Tue, 1/4/11, Jeff Kletsky <gnucash at allycomm.com> wrote:
> From: Jeff Kletsky <gnucash at allycomm.com>
> Subject: Re: Reducing File Size
> To: "Mike C." <subscribe307 at verizon.net>
> Cc: "Derek Atkins" <warlord at MIT.EDU>, gnucash-user at gnucash.org
> Date: Tuesday, January 4, 2011, 11:08 AM
> "32 seconds to generate an Income
> Statement, and 53 seconds to generate a Balance Sheet"
> In my experience, the problem with the reports is the
> "legacy" Scheme HTML generation. The way that HTML is
> generated is very inefficient.
> I'm going to have to tackle reports for budgeting now that
> 2.4 is out as, even with one-year's worth of data, the
> generation time is unacceptable using legacy reporting.
> eGuile looked like a huge step forward when I tried some
> early steps last spring. I'll probably give that a shot
> before trying something more extreme (external reporting off
> the database).
> On 01/04/2011 08:19 AM, Mike C. wrote:
> > I timed it to give you a good answer. It takes
> 67 seconds to load the
> > program, 32 seconds to generate an Income Statement,
> and 53 seconds to
> > generate a Balance Sheet. I can tolerate this
> but would like to get rid
> > of some useless data to improve the performance.
> I have a data file
> > with just a few entries to verify certain program
> attributes and it
> > loads in about 20 seconds and the reports load in 5-10
> > Mike
> > On 1/3/2011 11:17 AM, Derek Atkins wrote:
> >> "Mike C."<subscribe307 at verizon.net>
> >>> I have the same problem that several others
> have mentioned. Since I
> >>> converted over 15 years of Quicken data the
> Gnucash file is now 1845 KB
> >>> after compression and takes a long time to
> load or to generate reports.
> >>> I would like to eliminate old data that is no
> longer needed without
> >>> affecting the current account totals.
> >> Can you please define "a long time to load or to
> generate reports?"
> >> I've got 7 years of transactions in my data file
> and most of my reports
> >> generate within a few seconds. (Some take
> longer, but that's more a
> >> problem with the report algorithms, which will get
> fixed over time).
> >>> Please remember to CC this list on all your
> >>> You can do this by using Reply-To-List or
> >> -derek
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> gnucash-user mailing list
> gnucash-user at gnucash.org
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
More information about the gnucash-user