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

Reply via email to