We have a simple application built with Couchbase. Our problem is that when purging all documents the sqlite database remains more or less the same size, why is this? We are using Couchbase Lite 2.1.3 (Swift)
Here is what we do:
We have a Couchbase server with 40k documents (no attachments).
We launch the application with a user that subscribes on all channels so everything is synchronised. The database size (not the WAL or shm but the other one named only sqlite3) is 115Kb before the synchronisation and around 80mb after.
We stop the replicator, purge all documents and compact, change the users channels to subscribe on NO channels and then we start the replicator again. This all seems to work fine. When looking at the database through a sqlite software, all documents are gone but the sqlite file is still 80 mb.
Why is this and what can we do? We really do not want to delete the database.