WAL files can be many times bigger than a database - the default WAL checkpoint size is when the WAL grows to > 1000 pages. You can get a DB (for example) with 100 pages and a WAL of 1000 (with multiple different copies of the same page). Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence
On 26 February 2016 at 08:46, Rowan Worth <rowanw at dugeo.com> wrote: > On 24 February 2016 at 21:49, Richard Hipp <drh at sqlite.org> wrote: > >> On 2/24/16, Simon Slavin <slavins at bigfraud.org> wrote: >> > Why can't the information which SQLite >> > stores in a journal file be put in the database file ? >> >> Doing so would double the size of the database file. Every database >> file would contain extra space (normally unused) set aside for the >> journal. >> > > Surely this extra space would be proportional to the size of the largest > [recent] transaction, rather than the size of the database itself? To be > specific I'm thinking of rollback journals, I don't have experience with > WAL mode. > > -Rowan > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users