You may be hitting the memory fragmentation issue. Try to run your application with different memory managers (Hoard is my favorite - http://www.hoard.org/) and see if the memory consumption is the same.
Also if you close all connections to your database (and other SQLite databases too) does amount of used memory get lower? Pavel On Fri, Dec 28, 2012 at 7:04 AM, Krzysztof <dib...@wp.pl> wrote: > Hi, > > I'm using PRAGMA temp_store=2 so all temp tables are created in memory. I > have temp table with 1 000 000 000 records. Memory used by my test > application grow up to ~80 MB. 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? > > Regards > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
