On 26.07.2016 12:53, Dan Kennedy wrote:

The corrupt database thing is unexpected, of course. It might be fixed
here:

  http://sqlite.org/src/info/483994a54dee3c7a

Please let us know if you get the chance to try the fix above with your
databases.

I confirm that the fix solves the problem reported.

Unlike VACUUM, sqlite3_scrub_backup() should not usually shrink the
database. scrub_backup() simply creates a copy of the original database
with any unused parts of the file (i.e. free pages or empty space within
b-tree pages) zeroed out. Whereas VACUUM rebuilds the db from the ground
up so that it is as small as possible.

Understood. Thanks for the info!

Ralf
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to