Speeding up gnucash

[Geert Janssens]

On Wednesday 26 February 2014 23:35:39 AC wrote:
> On 2/26/2014 21:56, John Ralls wrote:
> > On the other hand, the SQL backend saves incrementally, so that part
> > is much faster. There's a caveat that there may be some corner
> > cases where the SQL backend doesn't save at all, so be very careful
> > using it at first. If you can use the SQL backend, particularly
> > with MySQL or Postgresql (meaning that you know how to administer
> > one of those servers), you can just leave GnuCash running most of
> > the time and avoid the load time, assuming that your usage doesn't
> > bump up against any of those corner cases... but if it does, that
> > could be good, too, because then we'd know about that corner case
> > and could fix it.
> No problem, I already run many MySQL servers on other machines here.
> One more isn't an issue.  I'm hoping there's some documentation on how
> to set up gnucash to use the DB backend on Windows.  And I do usually
> leave gnucash running so the incremental saves would be great, that's
> usually what's happening to cause the slowdowns.
> 
GnuCash on Windows comes with the necessary components to connect to a MySQL database 
out of the box.

To do so, you can open an existing gnucash file or create a new one as you like. Then you "save" 
it once to mysql. That is, you run File->Save as. In the dialog that pops up you can select 
"MySQL" as "Data Format" and enter the database parameters.

You will have to preconfigure your mysql server to allow the gnucash database user to create 
the database or precreate an empty database depending on your security preferences.

Regards,

Geert