[GNC] Archiving transactions

[D]

Rizwan,

I am intrigued. You say you're a new user, but you have 500,000 transactions. Wow! 

You've been getting the usual kinds of responses to your question: how fast is your computer, how many reports are you running, be patient, don't close Gnucash, etc.

But it sounds as if you're pushing boundaries that most of us personal/small business users aren't. For example, my data file loads and runs pretty well. It covers over ten years of transactions, and the last time I checked, it was around 200,000 transactions all told. It may be that you are an outlier user who tests the functional limits of Gnucash. 

One major issue that has long been known is that the software is not built to think like a database app. It loads the entire data file into memory on start up. It does this even with the SQL back ends, which is a roundabout way to tell you that changing to a database back end won't help at this time, sadly.

I see that you had another query about transaction imports that suggests that you have some programming experience. Many of us would cheer if you were to put that experience to work helping the small development team. One really big area they are looking at is the migration of Gnucash to a true db app--a long term goal, to be sure, since there are so many immediate issues that need to be addressed.

Cheers,
David T.

On November 18, 2019, at 8:17 AM, David Carlson <david.carlson.417 at gmail.com> wrote:

There is a setting under Edit > Preferences > General to compress the data
file.  I think it is selected by default.  In Windows 10 compression
happens very fast so that is not likely to be an issue with speed.

However, because the entire database is [theoretically] in RAM, at some
point that will cause RAM to spill over into swap space on the local
drive.  Then things really slow down.  This will happen more quickly if a
web browser is running concurrently.  In Windows open the Task Manager and
look under performance to see how your machine is doing.

David Carlson

On Sun, Nov 17, 2019 at 8:14 PM M. Rizwan Muzzammil <m.rizwan at gmail.com>
wrote:

> I will check. Thanks for the suggestion.
>
> On Mon, Nov 18, 2019, 10:06 AM Greg Feneis <mfeneis at gmail.com> wrote:
>
> > It seems like there used to be an option to encrypt, or zip the working
> > file when it's the default xml type. If that's still an option, and is
> > enabled, it could cause a delay relative to the file size
> >
> > Kind regards, Greg Feneis
> > (Pixel 3)
> >
> >
> > On Sun, Nov 17, 2019, 17:49 M. Rizwan Muzzammil <m.rizwan at gmail.com>
> > wrote:
> >
> > > Thanks for your reply....I am using the default file types. Does it
> make
> > a
> > > difference if I change?
> > > If so to what other type and how can it be done?
> > >
> > >
> > >
> > >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > 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
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


-- 
David Carlson
_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.