[GNC] GnuCash very slow to start up and quit

[Tim Hume]

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.