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@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](https://protonmail.com/) secure email. > _______________________________________________ > gnucash-user mailing list > gnucash-user@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@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.
