Re: [sqlite] rollback/replay journals and durability of the mostrecent transaction

2008-07-03 Thread D. Richard Hipp
On Jul 2, 2008, at 11:07 PM, Ken wrote: > > So if I insert large amounts of data, this data would be written to > disk > twice: once into a replay journal, and then again into the database > file > on commit. With rollback journal, it is written once into the database > (with rollback journal

Re: [sqlite] rollback/replay journals and durability of the mostrecent transaction

2008-07-02 Thread Ken
Igor Tandetnik <[EMAIL PROTECTED]> wrote:Karl Tomlinson wrote: > Thank you for your comments. > >>> Karl Tomlinson wrote: >>> One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction)

Re: [sqlite] rollback/replay journals and durability of the mostrecent transaction

2008-07-02 Thread Igor Tandetnik
Karl Tomlinson <[EMAIL PROTECTED]> wrote: > Thank you for your comments. > >>> Karl Tomlinson wrote: >>> One thing I'm trying to understand is whether there was a reason for SQLite choosing to use a rollback journal (of the steps to undo a transaction) rather than a replay journal