GNU cash slow to load

[Jamestk]

Thanks for all of the suggestions which put my mind at rest.
I think the best option for me is to archive older accounts off when they become redundant. I guess there is a feature built in somewhere but haven't come across it as yet.
Overall it's a very enjoyable program to use especially using the 'jump'feature which saves me a huge amount of time.
btw, I only received an email notification to the last post by Paul?
Cheers, 
David

Date: Mon, 1 Apr 2013 10:14:48 -0700
From: ml-node+s1415818n4660871h82 at n4.nabble.com
To: davidjamestk at hotmail.co.uk
Subject: Re: GNU cash slow to load



	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)

	
	
	
	

	

	
	
		If you reply to this email, your message will be added to the discussion below:
		http://gnucash.1415818.n4.nabble.com/GNU-cash-slow-to-load-tp4660791p4660871.html
	
	
		
		To unsubscribe from GNU cash slow to load, click here.

		NAML
	 		 	   		  



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