I have just checked a twitter database from a library of test DBs - the DB is 88Kb and the associated WAL is 4012Kb similarly I have a Safari history.DB that is 294Kb and associated WAL that is 3974Kb.
these are the bigger ones in my test library but they are real world databases 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 09:32, Paul Sanderson <sandersonforensics at gmail.com> wrote: > 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
