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:
> 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?

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