=?ISO-8859-1?Q?Daniel_=D6nnerby?= <[EMAIL PROTECTED]> wrote: > Hi all! > > I have a multithreaded application where every thread (almost) has it's > own sqlite connection to the same database. > The database is only accessed by this application and the application > always run on the same computer as the database. > My question: > Is it "safe" to set "PRAGMA synchronous=OFF"? > > The database is not critical, so I'm not that worried if the database > gets corrupted on powerfailure. But the important thing is that, when > INSERTing in one thread, it should be able to be read by another thread > when transaction is done. >
Yes. PRAGMA synchronous=ON only prevents damage that results from power failures and/or operating system crashes. Application program crashes will not corrupt the database even if PRAGMA synchronous=OFF. -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
