[GNC] GnuCash very slow to start up and quit

[Tim Hume]

Oops. It reduced the file size to about 35.5 MByte :-)

Sent with ProtonMail Secure Email.

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Sunday, June 20th, 2021 at 12:31, Tim Hume <tim at nomuka.com> wrote:

> Hi,
>
> I tried the vacuum command. Here's how to do it from the command line:
>
> sqlite3 database_name 'VACUUM;'
>
> It reduced the size of my database file from about 37.2 MByte to 37.5 MByte, which is worth having. But the start up time remained unchanged at about 1m09s. I guess my file is just very big.
>
> Cheers,
>
> Tim
>
> Sent with ProtonMail Secure Email.
>
> ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐
>
> On Monday, June 14th, 2021 at 21:13, Chris Green cl at isbd.net wrote:
>
> > On Mon, Jun 14, 2021 at 07:00:58AM -0400, R. Victor Klassen wrote:
> >
> > > When I had speed problems it was much more extreme. I had been using SQLite.
> > >
> > > I switched to XML, and then switched back, and the effect of saving it
> > >
> > > in a different format, and reading it back was enough to make a dramatic
> > >
> > > improvement. There was something in the data file that made it slow, and
> > >
> > > that was cleaned up by the change of format.
> >
> > Isn't there some sort of 'clean up and make it more efficient' utility
> >
> > for sqlite databases? ...., yes, it's the VACUUM statement.
> >
> > I think that might well be worth trying.
> >
> > Chris Green
> >
> > gnucash-user mailing list
> >
> > gnucash-user at gnucash.org
> >
> > To update your subscription preferences or to unsubscribe:
> >
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> >
> > If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > --------------------------------------------------------------------------------------------------------------
> >
> > Please remember to CC this list on all your replies.
> >
> > You can do this by using Reply-To-List or Reply-All.