Incredibly slow backups problem and perhaps a solution

[ts678]

Release History for SQLite supports the thinking:

2017-03-30 (3.18.0)

1. Added the PRAGMA optimize command

@stahr

Unless Duplicati contains its’ own version of sqlite3

Current Beta (and many prior) ship only a Windows SQLite. On Linux, it uses the system copy.
This is (I think) changing with current Canary, although I don’t know for sure if change will stay:

@kenkendk

@ts678

Did we mean to ship our own SQLite? If so, is it available in all the binary flavors we’re shipping?

Right now all the packages are using the SQLite NuGet packages which includes arch-specific binaries, and it appears to be available in all the flavors (have not tested if it works with Arm7).

Feel free to test Canary if you like, but note that they’re first exposures of new fixes and bugs.

EDIT:

Solidify SQLite dependencies #4024 discusses the drawback of running on a system’s SQLite. Current emerging direction of Duplicati is fewer dependencies. Doesn’t even need mono either.