I did cause quite a GnuCash discussion here in Mar 2017, but this time I have one simple question. Since it is difficult to quickly create a large GnuCash test data file, does anyone here know about GnuCash performance on a "large" file of about 20,000 transactions? Specifically: 1. How long do the load/open and save/close operations take? 2. How smooth or snappy are various navigations, scrolling/paging up/down, searching, filtering, etc.? 3. Are there any dangers of data loss due to possible GnuCash "comfortable size" limits?
Hartmut W Sager - Tel +1-204-339-8331
On Sun, 2019-04-21 at 15:15 -0500, Hartmut W Sager wrote:
I did cause quite a GnuCash discussion here in Mar 2017, but this time I have one simple question. Since it is difficult to quickly create a large GnuCash test data file, does anyone here know about GnuCash performance on a "large" file of about 20,000 transactions? Specifically:
- How long do the load/open and save/close operations take?
- How smooth or snappy are various navigations, scrolling/paging
up/down, searching, filtering, etc.? 3. Are there any dangers of data loss due to possible GnuCash "comfortable size" limits?
My household accounts file contains 18 years of transactions and is 1.4MB using the compressed XML format. Loading it takes under 5 seconds, saving takes less than 2. Nothing else I do takes noticeable time, but I don't use reports or file attachments.
(GnuCash 2.6 19, Ubuntu 18.04, i7-8850U, 8GiB RAM, M.2 SSD)
Thanks! (I hope to hear from others too.) Can you give me some idea of how many transactions you have? BTW, my own data is for 27 years, but my query is for myself and one or more other people.
I would probably not use file attachments either, and reports would be run infrequently so their performance would not matter.
Re "the compressed XML format", are you applying compression yourself, or does GnuCash have the option of applying compression to its normally extremely space-consuming XML format? (I have looked at its XML quite closely.)
Hartmut W Sager - Tel +1-204-339-8331
On Sun, 21 Apr 2019 at 16:51, Glen Ditchfield GJDitchfield@acm.org wrote:
On Sun, 2019-04-21 at 15:15 -0500, Hartmut W Sager wrote:
I did cause quite a GnuCash discussion here in Mar 2017, but this time I have one simple question. Since it is difficult to quickly create a large GnuCash test data file, does anyone here know about GnuCash performance on a "large" file of about 20,000 transactions? Specifically:
- How long do the load/open and save/close operations take?
- How smooth or snappy are various navigations, scrolling/paging
up/down, searching, filtering, etc.? 3. Are there any dangers of data loss due to possible GnuCash "comfortable size" limits?
My household accounts file contains 18 years of transactions and is 1.4MB using the compressed XML format. Loading it takes under 5 seconds, saving takes less than 2. Nothing else I do takes noticeable time, but I don't use reports or file attachments.
(GnuCash 2.6 19, Ubuntu 18.04, i7-8850U, 8GiB RAM, M.2 SSD)
Roundtable mailing list Roundtable@muug.ca https://muug.ca/mailman/listinfo/roundtable
On Sun, 2019-04-21 at 17:38 -0500, Hartmut W Sager wrote:
Thanks! (I hope to hear from others too.) Can you give me some idea of how many transactions you have?
About 10,700 transactions.
Re "the compressed XML format", are you applying compression yourself, or does GnuCash have the option of applying compression to its normally extremely space-consuming XML format?
GnuCash does it. There's a setting in Preferences » General. I switched over long ago, and at the time the reduced I/O time was significant.
Well, maybe I shouldn't be revisiting GnuCash after all. It is already failing me again on my latest experiments (and their official outstanding buglist is 4 screen pages long!). After 21 years and 100's of sub-versions, does this thing ever grow up?
My latest: When I do "File" (pulldown) and then "New file" (to start a new company), the (Windows) GnuCash 3.4 hangs totally with everything greyed out, and I have to kill it from Task Manager. And this is fully repeatable. Yes, I have an open company file in GnuCash when I do this, only because there is no "Close current company" (a ridiculous omission). There's also no option in "Preferences" to open GnuCashwithout it trying to open the last company file it had open.
A poor workaround that did work is to move all existing company files to another directory before opening GnuCash, but then of course it complains about a broken reference.
Hartmut W Sager - Tel +1-204-339-8331, +1-204-515-1701, +1-204-515-1700, +1-810-471-4600
---------- Forwarded message --------- From: Hartmut W Sager hwsager@marityme.net Date: Sun, 21 Apr 2019 at 17:38 Subject: Re: [RndTbl] GnuCash revisited To: GJDitchfield@acm.org, Continuation of Round Table discussion < roundtable@muug.ca>
Thanks! (I hope to hear from others too.) Can you give me some idea of how many transactions you have? BTW, my own data is for 27 years, but my query is for myself and one or more other people.
I would probably not use file attachments either, and reports would be run infrequently so their performance would not matter.
Re "the compressed XML format", are you applying compression yourself, or does GnuCash have the option of applying compression to its normally extremely space-consuming XML format? (I have looked at its XML quite closely.)
Hartmut W Sager - Tel +1-204-339-8331
On Sun, 21 Apr 2019 at 16:51, Glen Ditchfield GJDitchfield@acm.org wrote:
On Sun, 2019-04-21 at 15:15 -0500, Hartmut W Sager wrote:
I did cause quite a GnuCash discussion here in Mar 2017, but this time I have one simple question. Since it is difficult to quickly create a large GnuCash test data file, does anyone here know about GnuCash performance on a "large" file of about 20,000 transactions? Specifically:
- How long do the load/open and save/close operations take?
- How smooth or snappy are various navigations, scrolling/paging
up/down, searching, filtering, etc.? 3. Are there any dangers of data loss due to possible GnuCash "comfortable size" limits?
My household accounts file contains 18 years of transactions and is 1.4MB using the compressed XML format. Loading it takes under 5 seconds, saving takes less than 2. Nothing else I do takes noticeable time, but I don't use reports or file attachments.
(GnuCash 2.6 19, Ubuntu 18.04, i7-8850U, 8GiB RAM, M.2 SSD)
Roundtable mailing list Roundtable@muug.ca https://muug.ca/mailman/listinfo/roundtable
-
Glen Ditchfield -
Hartmut W Sager