[GNC] XML or database?

[Derek Atkins]

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