[GNC] GnuCash performance issue on larger accounts

[Kalpesh Patel]

I haven't archived my data since I imported all data from Quicken from early nineties when I moved over to GNC in 2017. All transactions is in a single XML file.  My compressed data file is just slightly bigger than 4.1MB and I don’t see any performance issues. I am also on Windows 11 but running latest 4 series of GNC.

-----Original Message-----
From: Doug <lemans4 at internode.on.net> 
Sent: Wednesday, November 05, 2025 3:32 PM
To: R Losey <rlosey at gmail.com>
Cc: Haowen Liu <liu.haowen.andy at gmail.com>; gnucash-user at gnucash.org
Subject: Re: [GNC] GnuCash performance issue on larger accounts

My files go back 20+ years, & the file is 3.1M, but I do not run a complicated business.

 btw, thanks to all the developers! I am an old, old user (now retired).


On Wed, 5 Nov 2025 12:08:10 -0600
R Losey <rlosey at gmail.com> wrote:

> You don't need to archive data -- I have been using GnuCash for 9 
> years and have not cleared out old transactions. Others in this list 
> have even more data.
> 
> As John pointed out, there was a bug in the Windows version that was 
> making it sluggish. I used the latest stable build from the end of 
> October, and the problem went away.
> 
> On Tue, Nov 4, 2025 at 10:49 PM Haowen Liu <liu.haowen.andy at gmail.com>
> wrote:
> 
> > Hi all!
> >
> > I'm using GnuCash to manage my personal finance and I use one file 
> > per year. Towards the end of the year, the most active account 
> > currently have 950 transactions over the past year and GnuCash is 
> > visibly struggling when I input transactions there. Is this to be expected?
> > Should I break up files more, e.g. biannually?
> >
> > I'm on Windows 11 and GnuCash 5.13. The file is stored as sqlite. I 
> > also added the directory where I store the GnuCash sqlite file to 
> > antivirus exception list just in case something is scanning it more 
> > often than needed.
> >
> > Haowen
> >
> > _______________________________________________
> > 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
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> >  
> 
> 
> --
> _________________________________
> Richard Losey
> rlosey at gmail.com
> Micah 6:8
> _______________________________________________
> 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
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.