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

Reply via email to