RE: [sqlite] PRAGMA synchronous=0; and crash recovery

2007-10-02 Thread Andre du Plessis
I think everyone has this requirement, I was finding many slowness problems using synchronous = on, and I started tweaking the app with memory tables, I recommend you look into it, you can create a memory Database by specifying :memory: as the filename. The connection you receive from this you ca

Re: [sqlite] PRAGMA synchronous=0; and crash recovery

2007-10-01 Thread drh
"Scott Gilbert" <[EMAIL PROTECTED]> wrote: > > So my questions are: > > With synchronous = 0, are transactions still atomic across processes? yes > Is running with synchronous=0 likely to non-recoverably corrupt the > database file on power failure? yes > Are there any recovery to