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