Gnucash file is getting long!

[AC]

On 2017-06-16 09:35, Derek Atkins wrote:
> Adam Funk <a24061 at ducksburg.com> writes:
> 
>>> Not necessarily.  The "default" backend would be SQLite, which is a DB
>>> that stores into a single file.  So it will act like the current XML
>>> backend in terms of storage, but not necessarily the same with backup
>>> files.  However no server is required.
>>
>> Great!  Thanks to you & Colin for that information.
> 
> Also keep in mind that the mysql data isn't compressed, so your disk
> space usage will grow significantly when using a SQL backend vs the
> (compressed) XML.
> 

You can enable compression in MySQL 5.5.  This applies to InnoDB table
types using a file per table and the Barracuda file format.  This
configuration must be enabled before the tables are created.