GNU cash slow to load

[Paul Conrady]

Hello all,

Reading the above discuss piqued my interest, so I decided to run a quick
test. My results follow.

GnuCash loads in 13.04 sec. This is the program file only, absent any data,
reports, etc.

Data file only -                                Open                Save
XML (14.2 Mb; no compression):      10.07 sec          3.08 sec
XML (1.0 Mb; compression on):        10.66                3.46
SQLite3 (9.9 Mb):                              9.9                 not
required

I used the same data file in the tests. The difference in size in due to
compression. SQLite saves each transaction when entered in the GnuCash
register, therefore saves are "not required".

Comments: I use the SQLite3 backend because changes are saved to the file
immediately. (I have not used MySQL so I cannot comment.) The only downside
to the SQLite3 format is that incremental backup files are not automatically
produced by the program. This can be good or bad, depending on your point of
view. On one hand, your default folder is not filled with
"....gnucash.20130401095037.gnucash" backup files. On the other hand, you
must remember to manually create backup files. I prefer the latter method.

Probst! Paul

x86-P4 with hyperthreading
Ubuntu 10.04 LTS
GnuCash 2.4.11 (from r22264M)



--
View this message in context: http://gnucash.1415818.n4.nabble.com/GNU-cash-slow-to-load-tp4660791p4660871.html
Sent from the GnuCash - User mailing list archive at Nabble.com.