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@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.
