[GNC] Large GnuCash file very slow to write to

[Tim Hume]

It is an SSD drive (I'm using a Mac Mini about one year old - with the M1 chip).

The slow part seems to be saving the database - inserting the transactions is fast enough, the save operation is what takes so long. It may be 20 minutes - I haven't timed it. Even closing GnuCash is slow - perhaps 30 seconds to a minute.

Sent with ProtonMail secure email.
------- Original Message -------
On Sunday, May 8th, 2022 at 11:40, Kenneth Schneider <kschneider at bout-tyme.net> wrote:


> I don’t believe the file is getting too large. If you haven’t looked into using an SSD drive at least for the database I highly recommend it. Not only will you amazed at how fast data will be written to the file but also how fast you will be able to generate reports.
>
> Ken Schneider
>
> > On May 8, 2022, at 7:24 AM, Tim Hume via gnucash-user gnucash-user at gnucash.org wrote:
> >
> > Hi,
> >
> > My GnuCash file (SQLite format) has become rather large - 110 MBytes. Every month or two I import a lot more transactions in CSV format. I use piecash in a Python script I wrote, because the importing of CSV data built into GnuCash crashes when I import too many transactions.
> >
> > I might be importing perhaps 4000 or 5000 transactions. Saving them into my GnuCash file takes many many minutes. I know my file is getting too large, but it surely shouldn't take 10+ minutes to do this operation? Whilst I do it, I can see Python is taking 100% of a CPU core.
> >
> > Come the end of the financial year (30 June) I'm going to start a new file. But this will quickly grow in size, and no doubt I'll run into this problem again. Is there anything I can do to speed this up, or do I just have to live with it?
> >
> > Cheers,
> >
> > Tim.
> >
> > Sent with ProtonMail secure email.
> > _______________________________________________
> > 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.