On Apr 21, 2009, at 9:25 AM, Marco Bambini wrote: > 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
Dan tells me that if another process has a read lock on the database file while your process is running the large transaction, then the size of the page cache can grow without bound. That seem likely what is happening here. > > 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 D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
