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
OK. I'll see if I can reproduce the problem 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
