On 28 Dec 2012, at 3:04pm, Krzysztof <dib...@wp.pl> wrote: > If I delete all records from this table or > drop table, then my application still use 80 MB of memory. I have tried > also PRAGMA shrink_memory. Why sqlite don't free memory?
SQLite does not free up space from a database until it does a VACUUM. Either use the command for it: <http://www.sqlite.org/lang_vacuum.html> or use the auto-vacuum pragma: <http://www.sqlite.org/pragma.html#pragma_auto_vacuum> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users