Re: [sqlite] disabling journalling of the database - side affects?

2005-11-01 Thread Christian Smith
On Tue, 1 Nov 2005, Gerry Snyder wrote: >Allan, Mark wrote: >> >> >> We do believe however that journaling the database for us >> is of no benefit as our filing system is 100% fail safe and will >> return to the last flushed state of the file on power loss. > >Mark, > >I am probably in over m

RE: [sqlite] disabling journalling of the database - side affects?

2005-11-01 Thread Allan, Mark
supposed to be happening. Regards Mark > -Original Message- > From: Gerry Snyder [mailto:[EMAIL PROTECTED] > Sent: 01 November 2005 14:58 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] disabling journalling of the database - side > affects? > &

Re: [sqlite] disabling journalling of the database - side affects?

2005-11-01 Thread Gerry Snyder
Allan, Mark wrote: We do believe however that journaling the database for us is of no benefit as our filing system is 100% fail safe and will return to the last flushed state of the file on power loss. Mark, I am probably in over my head, as usual, but how do you recover if power go

RE: [sqlite] disabling journalling of the database - side affects?

2005-11-01 Thread Allan, Mark
PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 01 November 2005 11:49 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] disabling journalling of the database - side > affects? > > > "Allan, Mark" <[EMAIL PROTECTED]> wrote: > > I definately have a problem when

Re: [sqlite] disabling journalling of the database - side affects?

2005-11-01 Thread drh
"Allan, Mark" <[EMAIL PROTECTED]> wrote: > I definately have a problem when I disable journalling on version 3.2.7 > of SQLite. I dont see the same problem with 3.2.1 of SQlite. > I disable the journalling of the database file as described in my > earlier email. > With version 3.2.7 this causes S

RE: [sqlite] disabling journalling of the database - side affects?

2005-11-01 Thread Allan, Mark
I definately have a problem when I disable journalling on version 3.2.7 of SQLite. I dont see the same problem with 3.2.1 of SQlite. I disable the journalling of the database file as described in my earlier email. With version 3.2.7 this causes SQlite to not sync the database file after some upd