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. Is there any
reliable method to determine the minimum page-cache allocation size
needed for a given page_size?

 

Cheers,

Dave Toll.

 

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

Reply via email to