On Sep 8, 2008, at 8:28 PM, Dave Toll wrote: > Hello list > > > > I'm using SQLite 3.6.2 on an embedded C platform, and I recently > switched from memsys3 to memsys5. SQLite memory usage > (sqlite3_memory_used()) for a fully-cached database nearly doubled > from > 4.7MB to 8.9MB (using the same DB file in each test). Is this > normal/expected? > > > > I've also played with SQLITE_CONFIG_PAGECACHE, which seems to be more > appropriate for a limited-memory system where the amount of data will > often be close to the memory limit. I discovered that it was necessary > to allow an overhead on top of the page_size when specifying the > page-cache allocation size (sz argument), otherwise the page-cache > would > not be used as the page-cache units were too small.
Have you read http://www.sqlite.org/malloc.html > Is there any > reliable method to determine the minimum page-cache allocation size > needed for a given page_size? > sqlite3_status(SQLITE_STATUS_PAGECACHE_SIZE, ...) D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users