HI all, 

I'm trying to use the memsys5 subsystem (3.6.2). I've run the configs for the 
MEMSTATUS, HEAP, SCRATCHBUF:

During processing I get an out of mem error returned from a select statement.

Here is the output of various sqlite3 memory highwater marks.
SQLITE_STATUS_MEMORY_USED [65469440]
SQLITE_STATUS_PAGECACHE_USED [15985]
SQLITE_STATUS_PAGECACHE_OVERFLOW [63883264]
SQLITE_STATUS_SCRATCH_USED [2]
SQLITE_STATUS_SCRATCH_OVERFLOW [0]
SQLITE_STATUS_MALLOC_SIZE [524288]
SQLITE_STATUS_PARSER_STACK [0]
SQLITE_STATUS_PAGECACHE_SIZE [4360]
SQLITE_STATUS_SCRATCH_SIZE [30696]

Any suggestions as to where I'm running out of memory ? 
Also, I'm not certain why the pagecache is overflowing. 

thanks, Ken



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to