Speeding up gnucash

David J. Bakeman dbakeman at comcast.net
Thu Feb 27 12:08:08 EST 2014


On 02/26/2014 08:05 PM, John Ralls wrote:
> On Feb 26, 2014, at 7:14 PM, AC <gnucash at acarver.net> wrote:
>
>> I'm currently running the Windows version 2.4.15.  Is there a way to
>> speed up the read and write operations?  Right now when I save my
>> updates it takes about two minutes to write everything to disk.  When
>> loading, it can sometimes take a while to load the file and populate the
>> registers.
> Heh. You think 2.4.15 is slow, try 2.6.1.
>
> Unfortunately, reading a large file and creating all of the objects or serializing all of the objects and writing them back into a file is slow. After a couple of bug reports about files being corrupted by invalid UTF8 and ASCII control characters, the latter of which are illegal in XML, 2.6 introduced checking every string for invalid characters. That slows down loads, imports, and saves even more.
So every time the database is loaded and saved it's sanitized?  How
would the bad chars get in while gnucash is running?  If it's from the
import transaction stuff shouldn't they do the checking?  That way the
database used while gnucash is running is always sanitized.  So checking
can be skipped during the save.  Further couldn't you then mark the save
as clean so when you load the database the next time you can skip the
check?
>
> The only thing you can do is to shrink your file. There's no automatic way to do it: You need to first make a backup, then pick a date and create an Opening Balance transaction for that date for every account. Once you've done that, you can delete all of the transactions in before the date.
>
> Regards,
> John Ralls
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



More information about the gnucash-user mailing list