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 data which are not written to the disk? And how can I force sqlite to write these data on disk? Thanks! BR Rick _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users