[sqlite] journal file and its size

2015-07-15 Thread Simon Slavin
On 15 Jul 2015, at 6:40pm, Mayank Kumar (mayankum) wrote: > -what do you mean by journal file is created only when needed ? Is it not > true, that for any transactions it is always created. Yes, but many programs keep a connection to the database the whole time they're run, but seldom do

[sqlite] journal file and its size

2015-07-15 Thread Mayank Kumar (mayankum)
...@mailinglists.sqlite.org] On Behalf Of Clemens Ladisch Sent: Wednesday, July 15, 2015 5:43 AM To: sqlite-users at mailinglists.sqlite.org Subject: Re: [sqlite] journal file and its size Mayank Kumar (mayankum) wrote: > Sometimes we see the journal file not present on the system although > active transa

[sqlite] journal file and its size

2015-07-15 Thread Clemens Ladisch
Mayank Kumar (mayankum) wrote: > Sometimes we see the journal file not present on the system although > active transactions are ongoing. How is that possible since the > documentation says the journal file is always created in exclusive > mode ? The journal file is created only when it is needed.

[sqlite] journal file and its size

2015-07-15 Thread Mayank Kumar (mayankum)
Our application uses the following pragma with sqlite 3.7.7.1 PRAGMA synchronous=FULL; PRAGMA locking_mode=EXCLUSIVE"; I understand from the documentation that with exclusive mode the journal file is always created and never deleted until the exclusive mode is exited. Now my questions are:-