[GNC] Database storage

[Geoff]

Hi Chris

I have a GnuCash implementation with:

705 Accounts
53,083 Splits ("legs" of a Transaction)
44MB when stored as Uncompressed XML
28MB when stored as Sqlite Database

I run this on an ancient Windows PC driven by an Intel 3rd generation 
chip (i3770) and stored on a SATA SSD.

It takes about 10 seconds to open the GnuCash program and load the file 
into DDR3 RAM.  Transactional data entry is instantaneous (or at least 
far faster than I can type).  Common reports (Balance Sheet, P&L over 12 
month period) take about 10 seconds to complete.  On contemporary 
hardware (DDR5 RAM, NVMe storage) I would expect it to be quicker.

To paraphrase the proverb: "Performance is in the stopwatch of the user".

Hope this reassures you.

Regards

Geoff
=====

On 19/09/2024 11:53 am, Chris Miller via gnucash-user 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,