Can I stop compaction?

[Jordan Wood]

I have decided to do my database compaction when my app transitions into the background, so I am putting the call to compact in a background task using beginBackgroundTaskWithExpirationHandler.  I'm trying to figure out what to do if the OS decides that my background task has to stop before compact is done.  Can I call [database stop], to stop compaction?  I understand that compact spends most of its time in a few calls to SQLite, is there any way that be stopped gracefully?

[Jens Alfke]

On Dec 3, 2015, at 7:50 AM, Jordan Wood <wood.p...@gmail.com> wrote:

Can I call [database stop], to stop compaction?  

Nope. Compaction is a synchronous operation and there’s no way to interrupt it. On the other hand, if you compact often, i.e. on ever suspend, the task won’t take very log since there’s not much to do.

This will improve a lot in CBL 1.2 with ForestDB databases — the db will auto-compact periodically without you needing to do anything, and the background compaction task can handle being interrupted if app quits.

—Jens

[Brendan Duddridge]

I believe that you can enable auto-vacuum on SQLite, but I'm not sure if Couchbase Lite takes advantage of that. I know it does more than just vacuums the database. It also purges unreferenced attachments.

Brendan

[Jens Alfke]

On Dec 3, 2015, at 10:54 AM, Brendan Duddridge <bren...@gmail.com> wrote:

I believe that you can enable auto-vacuum on SQLite, but I'm not sure if Couchbase Lite takes advantage of that. I know it does more than just vacuums the database. It also purges unreferenced attachments.

And deletes obsolete revisions. Vacuum is only a small part of what compaction does.

—Jens