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,
_______________________________________________
gnucash-user mailing list
gnucash-user@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.
