cache_size is set to default 2000, page size is 1K... here you go the output of sqlite3_status: 2009-04-21 15:24:25 SQLITE_STATUS_MEMORY_USED current: 106704136 high: 109873952 2009-04-21 15:24:25 SQLITE_STATUS_PAGECACHE_USED current: 0 high: 0 2009-04-21 15:24:25 SQLITE_STATUS_PAGECACHE_OVERFLOW current: 4816736 high: 4819808 2009-04-21 15:24:25 SQLITE_STATUS_SCRATCH_USED current: 0 high: 0 2009-04-21 15:24:25 SQLITE_STATUS_SCRATCH_OVERFLOW current: 0 high: 6664 2009-04-21 15:24:25 SQLITE_STATUS_MALLOC_SIZE current: 1014 high: 52000 2009-04-21 15:24:25 SQLITE_STATUS_PARSER_STACK current: 0 high: 0 2009-04-21 15:24:25 SQLITE_STATUS_PAGECACHE_SIZE current: 0 high: 0 2009-04-21 15:24:25 SQLITE_STATUS_SCRATCH_SIZE current: 4480 high: 6664
-- Marco Bambini http://www.sqlabs.com http://www.creolabs.com/payshield/ On Apr 21, 2009, at 3:12 PM, D. Richard Hipp wrote: > > On Apr 21, 2009, at 9:07 AM, Marco Bambini wrote: > >> The database is on-disk ... does huge not committed transactions uses >> memory? >> > > It should do writes to disk periodically to free up memory, once you > hit your cache_size limit. > > What is cache_size set to. What are the output from sqlite3_status() > telling you about 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
