Hi, I was wondering what the size (in MB) of a WAL file and of a shared/private cache is in SQLite. I'm running SQLite on an Android smartphone so space (RAM/"HDD") is scarce.
1. I understand that the WAL file is stored on the disk. Provided auto-checkpointing, how big would the WAL file grow? It says in the documentation: 1000 pages. How big is a page? Also, does WAL has any (significant) memory consumption (per connection/thead, or dependent on the WAL file size)? 2. I'm guessing a SQLite cache (connection private [SQLITE_OPEN_PRIVATECACHE] or shared [SQLITE_OPEN_SHAREDCACHE]) is stored in memory only (i.e. not on the disk), right? What's its size in memory? Or, on what factors does this size depend on? Thanks Sebastian _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users