On May 6, 2008, at 11:08 PM, Scott Hess wrote:
>
> I suppose in DELETE mode, SQLite will delete the journal for you, but
> I don't think it would hurt to do it yourself...
No, it's deadly to do it yourself. That is my point. Unless you very
carefully analyze the lock state of the database
>In PERSIST mode, you have two files associated with your database
>instead of one. Whenever you move, copy, or rename the database file
>you *must* also move, copy or rename the journal file to prevent
>database corruption.
>
>The persistent journal file uses disk space that might
On Tue, May 6, 2008 at 7:41 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>> Since PERSIST is likely to be faster than DELETE on
>> most platforms, is there ever a reason *not* to use
>> it?
>
> In PERSIST mode, you have two files associated with your database
> instead of one. Whenever you
>
>
> Since PERSIST is likely to be faster than DELETE on
> most platforms, is there ever a reason *not* to use
> it?
>
In PERSIST mode, you have two files associated with your database
instead of one. Whenever you move, copy, or rename the database file
you *must* also move, copy or rename
sday, May 06, 2008 3:25 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] PRAGMA journal_mode not implemented?
Bob Ebert wrote:
> Is journal_mode a future optimization? The atomic commit
> documentation
> (http://sqlite.org/atomiccommit.html) as well as the pragma
Bob Ebert wrote:
> Is journal_mode a future optimization? The atomic commit documentation
> (http://sqlite.org/atomiccommit.html) as well as the pragma docs
> (http://www.sqlite.org/pragma.html) make tantalizing references to this
> potentially useful optimization, but I've searched the 3.5.1 and
Is journal_mode a future optimization? The atomic commit documentation
(http://sqlite.org/atomiccommit.html) as well as the pragma docs
(http://www.sqlite.org/pragma.html) make tantalizing references to this
potentially useful optimization, but I've searched the 3.5.1 and 3.5.8
sources and I
7 matches
Mail list logo