[GNC] XML or database?

R Losey rlosey at gmail.com
Mon Oct 31 11:14:46 EDT 2022


That helps - thanks!

I assume that if I attempt to quit GnuCash with unsaved data, it will
remind me to save... but the current indications of unsaved data files have
been sufficient to remind me to save the data.

If you have data going back 15 years, I'm just getting started with 6 years
(heh).



On Mon, Oct 31, 2022 at 8:31 AM Derek Atkins <derek at ihtfp.com> wrote:

> Hi,
>
> On Mon, October 31, 2022 9:14 am, R Losey wrote:
> > This question may have been asked before, but I'm relatively new to this
> > mailing list.
> >
> > Is there any advantage to switching to the database format? Would it use
> > less space? My ".gnucash" file is about 1.5M currently, and opening it
> > takes mere seconds.
>
> The main advantage of using the SQL backend is that all changes are
> "saved" immediately, so you wont lose data because you "forgot to save"
>
> But no, the DB is most definitely NOT smaller; the XML file is compressed
> on save, so that 1.5MB would probably be more like 10-20MB of DB.
>
> > Long ago in my Quicken days, I would generally keep about 3 years of
> data
> > and then "archive" transactions older than that... I don't know if
> GnuCash
> > has (or needs) any similar feature.
>
> For what it's worth, I have data going back to like 2007 in my file.
> GnuCash does not really have an "archive" function (although there have
> been 3rd party tools that do that.
>
> Hope that helps!
>
>  _________________________________
> > Richard Losey
> > rlosey at gmail.com
>
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
>
> -derek
>
> --
>        Derek Atkins                 617-623-3745
>        derek at ihtfp.com             www.ihtfp.com
>        Computer and Internet Security Consultant
>
>

-- 
_________________________________
Richard Losey
rlosey at gmail.com
Micah 6:8


More information about the gnucash-user mailing list