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
...@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
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.
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:-
4 matches
Mail list logo