Archiving Records To Improve Performance

[Adrien Monteleone]

I’m not aware of any such function, but you could make multiple copies named for the year or year ranges you want, then delete all transactions in each that don’t fall in those years.

You’ll then need to edit the opening balances for each account for each file to reflect their ending balances from the prior file.

What might help instead is saving as either sqlite3 or mysql format instead of the default xml. Database versions update instantly, so there is no need to save.

Loading will still take a bit, but that will improve when GC moves to database setup by default and stops reading in the entire db into memory at startup.

Note, you don’t need to exit from GC if you don’t have to shutdown or logoff.

I leave my copy of GC running along with my computer, for months at a time. The only drawback to this is at present, scheduled transactions are not automatically alerted or generated. You’d have to click the “Since Last Run…” option to trigger them.


Regards,
Adrien

> On Jul 8, 2017, at 11:14 AM, Michael Luderitz <msluderitz at gmail.com> wrote:
> 
> I have been using Gnucash for over 5 years, accumulating all the data in a
> single file name. Opening the file and saving it has become more and more
> time consuming. Is there a way to archive the prior years so that only one
> or two years are carried forward in the active file?
> 
> -- 
> "To argue with a man who has renounced the use of reason is like
> administering medicine to the dead." - Thomas Paine
> _______________________________________________
> 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.