The database is on-disk ... does huge not committed transactions uses memory?
-- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Apr 21, 2009, at 2:27 PM, D. Richard Hipp wrote: > > On Apr 21, 2009, at 8:22 AM, Marco Bambini wrote: > >> 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. >> > > We do that kind of test all the time but we never get huge memory > usage like this. Are you sure you have opened on on-disk database and > not an in-memory database? > > 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
