I tried inserting a 20MB document into the Database. When I went to the path where db was stored, I noticed the size of the database was 90 MB. The document was only inserted once. Is there any other additional information being stored?
The attachment is stored as a file in a subdirectory, and only once.
The SQLite database file will grow and can contain unused space as well as obsolete document revisions. Use the Compact method to free up space.
The JSON document (which doesn’t contain any other attachments) was the very first document which was inserted into the database. The db was empty prior to that. DB didn’t include any revisions. I was wondering what could be the cause of that extra 70MB.