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