[GNC] Database storage

Liz edodd at billiau.net
Wed Sep 18 22:01:01 EDT 2024


On Wed, 18 Sep 2024 18:53:02 -0700 (PDT)
Chris Miller via gnucash-user <gnucash-user at gnucash.org> wrote:

> > It should be noted: GnuCash does *not* do database queries as it
> > processes transactions.  
> Well, that's disappointing ... and definitive. 
> 
> If this content is stored as flat XML, then I would expect it not to
> scale very well. When does it start having performance problems? 
> 
> Thanks for the help, 

Looking at my 2 biggest data files with data from about 1990 for one
and 1995 for the other
2.2 MiB (2351153 bytes)
1.5 MiB (1537242 bytes)

and I don't notice any delays on using these files.
This laptop is multiprocessor (20 cores) 

vendor_id	: GenuineIntel
cpu family	: 6
model		: 186
model name	: 13th Gen Intel(R) Core(TM) i9-13900H
stepping	: 2
microcode	: 0x4121
cpu MHz		: 400.000
cache size	: 24576 KB

but I don't notice any performance concerns with my old desktop.

Liz


More information about the gnucash-user mailing list