On 4/14/16, Cecil Westerhof <cldwesterhof at gmail.com> wrote: > I have seen several times that the journal was 4.6 KB, but that fter > committing the database had grown with 6 or 7 KB. No big problem, but I > find it strange. What could be happening here? I would expect it not togrow > more as 5 KB. >
The rollback journal records the original content of pages that already existed in the database at the start of the transaction. New pages added to the end of the database can be rolled back simply by truncating the database file, so those pages are not stored in the rollback journal. In WAL mode, the WAL file is a "roll-forward journal" and so the size of the WAL file is proportional to the size of the transaction, as you expected. -- D. Richard Hipp drh at sqlite.org