Re: [sqlite] Size of WAL file and cache

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 26/09/12 01:15, Sebastian Krysmanski wrote: > 1. I understand that the WAL file is stored on the disk. During a transaction the old pages and the new pages will both be present at some point no matter what mode is used. Consequently you should exp

[sqlite] Size of WAL file and cache

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