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