=?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]
-