Yes, executing sqlite3_memory_used () after 183,000 INSERT statement returns: 106,766,848. Database is never closed during application lifetime. Each statement is prepared, stepped and properly finalized.
P.S. the database is encrypted using your modules. -- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Apr 21, 2009, at 2:11 PM, D. Richard Hipp wrote: > > On Apr 21, 2009, at 8:08 AM, Marco Bambini wrote: > >> Hello guys, >> >> I am trying to write you again about a simple question... how can I >> limit sqlite memory usage during insert commands? It seems that the >> amount of memory usage increases when the number of objects inserted >> into the database is increased and memory is never freed. >> >> I tried to set PRAGMA cache_size with no luck ... I tried also to >> recompile with SQLITE_ENABLE_MEMORY_MANAGMENT and use >> sqlite3_soft_heap_limit but nothing seems to change. > > > How do you know that memory usage is increasing? Are you using > sqlite3_status() and/or sqlite3_memory_used() to measure memory usage? > > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > 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