Hi, I have auto vacuum switched off and do not perform a manual vacuum. In this scenario will the database size keep increasing when records are inserted even as records are deleted. As I understand from the documentation,
"When auto-vacuum is disabled and data is deleted data from a database, the database file remains the same size. Unused database file pages are added to a "freelist <http://www.sqlite.org/fileformat2.html#freelist>" and reused for subsequent inserts. So no database file space is lost. However, the database file does not shrink. " Database size will keep increasing if sqlite allocates new pages for records inserted instead of re-using the pages which have records deleted, but not in the free list. Could you clarify ? -Sreekumar _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users