On Sun, 13 Jun 2021 09:10:42 +
Tim Hume wrote:
> I just ran a test. My data file is 37 MByte in SQLite format, and 52
> MByte when in XML and uncompressed. However, the compressed XML is
> under 4 MByte.
>
> It took 1m 17s to open GnuCash with the compressed XML file, and 55s
> with the SQLi
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
>
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
Speed depends on not only the factors that you have identified, but other
factors as well. I have an instance of release 3.8 running in a Linux Lite
environment within a Virtualbox on a laptop. Of course this hardware has
its limits too.
I happen to normally store my compressed XML datafile on
On Sunday, June 13th, 2021 at 18:28, Saša Janiška wrote:
> Just wonder how does SQLite back-end compare with XML and whether you
> recommend one over the other? (my XML is 20MB uncompressed and under
> VCS).
I just ran a test. My data file is 37 MByte in SQLite format, and 52 MByte when
in XML
On Sun, 13 Jun 2021 08:28:12 +0100
Chris Green wrote:
> > Backend: SQLite database
> >
> Ditto
Just wonder how does SQLite back-end compare with XML and whether you
recommend one over the other? (my XML is 20MB uncompressed and under
VCS).
Sincerely,
Gour
--
As a lamp in a windless place d
On Sunday, June 13th, 2021 at 17:28, Chris Green wrote:
> the difference must simply be down to the size of database. I create
> a new accounts file each year, apart from anything else it keeps the
> auditor happy (church accounts) and it certainly keeps it small.
> Could you maybe split your sys
On Sun, Jun 13, 2021 at 06:31:25AM +, Tim Hume wrote:
> Hi,
>
> I've been using GnuCash for a number of years. I especially like how it
> can handle foreign currencies - a feature that the commercial software
> packages tend to charge extra for.
>
> But a continual annoyance is how slow Gn
