Re: [sqlite] synchronous issue

2010-08-09 Thread Lei, Rick (GE EntSol, SensInsp)
Database Subject: Re: [sqlite] synchronous issue On 9 Aug 2010, at 7:13am, Lei, Rick (GE EntSol, SensInsp) wrote: > In order to reduce the operation time, I set synchronous as OFF and > journal_mode as MEMORY by PRAGMA command. However I found that the data > may be lost after inserting a

Re: [sqlite] synchronous issue

2010-08-09 Thread Simon Slavin
On 9 Aug 2010, at 7:13am, Lei, Rick (GE EntSol, SensInsp) wrote: > In order to reduce the operation time, I set synchronous as OFF and > journal_mode as MEMORY by PRAGMA command. However I found that the data > may be lost after inserting a BLOB data, even when I use a commit > action. Yes,

[sqlite] synchronous issue

2010-08-09 Thread Lei, Rick (GE EntSol, SensInsp)
Hi, In order to reduce the operation time, I set synchronous as OFF and journal_mode as MEMORY by PRAGMA command. However I found that the data may be lost after inserting a BLOB data, even when I use a commit action. I think the reason is synchronous is off. How can I know that there is some