Sorry I can't solve your problem (too technical for me) but I have notes on the testing code.
On 5 Sep 2016, at 8:54pm, Allen <allen...@gmail.com> wrote: > sqlite3_busy_timeout(db, 0x70000000) Please don't do this. It makes things hard to read and dependent on architecture details, i.e. the width of an int. The time argument should be an integer specified in a human-readable manner, i.e. decimal. If you want to turn timeouts off, specify zero or a negative number. If you want to specify a specific value like 15 minutes then writing "15*60*1000" explains to anyone reading your code what you're doing and what you think you're doing. > sqlite3_exec(db, "PRAGMA PRAGMA wal_autocheckpoint = 0;", NULL, NULL, NULL) Is "PRAGMA PRAGMA" a copy/paste error ? Given how specific you are about your configuring I am surprised you don't declare PRAGMA threads = N Are each of your thread using their own handles or do they all share the same handle ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users