On 13 Apr 2011, at 12:14pm, James Green wrote: > sync=full does not work well for our app (no transactions). Far too slow.
If you're not syncing, then section 3.2 of the page Richard probably indicates what's causing your corruption. So for a while, leave that PRAGMA alone, accept that you're going to get slow running, and see whether this makes the corruption go away. If it does then you can tackle the speed problem separately without worrying about data corruption. It might be worth trying to figure out whether your storage system can handle the speed you're expecting. If you have multiple threads all trying to write at the same time can your hard disk handle that much data at that speed ? If not, then that's probably why you're finding the use of 'sync' to be too slow. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
