Archiving old transations

Russell Mercer rmercer206 at
Fri Jun 21 04:59:11 EDT 2013

Seeing this thread made me wonder how big my file is.  I have transactions
going back to 1999, including banking, investment accounts, loans, etc.
About a year ago, I switched over from the ".xml" file, to the "sqlite"
database.  The size of the file is ~22MB.

Generally, when I open the file, I have a number of tabs open, including
account registers and reports.  The reports definitely take some time, so
the total opening is probably 1-2 minutes.

As a test, I wanted to open it cleanly.  I closed all of the tabs, leaving
just the basic account tab.  I then closed Gnucash and reopened.  Total
time where it was showing the "Loading User Data" bar, was about 20
seconds.  That is for a 22MB SQLite database.  I am not sure what that
equates to in an .xml file, but I would imagine it is probably larger.

As to configuration, I'm running Gnucash 2.4.11.  I am running Windows 7 on
an ~2.1Ghz Intel i5 with 8GB of RAM.

My personal thoughts are that even when keeping all the tabs open that I
normally do, the time is by no means prohibitive.  I tend to leave it open
anyway, with autosave on.  I have no desire to archive my transactions
because they provide great history both for research and reporting.  I took
a lot of time to make sure all the transactions are in here, no need to
change that and make it more difficult.  Now that I've seen how quickly it
opens with the tabs closed, and since I saved all the custom reports, I'll
likely open Gnucash and the open the reports as needed instead of leaving
them open all the time.

I'm curious to see if my results are an anomaly, or if other people have
similar times.  I'm sure that since my length of tracking is short compared
to some people, my file could be significantly smaller.  Regardless,
compared to other software I use professionally, Gnucash is speedy.  The
only thing I could see putting some money toward, and since I haven't
looked, this may be happening, would be to check for memory leaks when it
is open.  I've noticed that when I leave Gnucash open for a long time, that
the amount of used memory slowly creeps up.  I'm sure this is an ongoing
process, and I should probably close it more often anyway for security sake.

Well, just wanted to give my 2 cents, and let the developers know that they
are appreciated.


On Fri, Jun 21, 2013 at 1:10 AM, Colin Law <clanlaw at> wrote:

> On 21 June 2013 06:22, Jonathan Kamens <jik at> wrote:
> > I pledge $100 toward a bounty to go to the developer who implements the
> > functionality that I need within GnuCash, payable in US dollars,
> bitcoins,
> > or beer, developer's choice.
> How many hours work would expect from your local car repair shop for
> $100?  How many hours do you expect from a software engineer?
> Colin
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at
> -----
> 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 mailing list