Re: [sqlite] Multithreaded vs. serialized

2009-01-14 Thread Dan
On Jan 15, 2009, at 6:07 AM, John Belli wrote: > Assuming I've decided to use evil threads, and am opening a new > connection in each thread, does it matter whether I use multithreaded > (-DSQLITE_THREADSAFE=2) or serialized (-DSQLITE_THREADSAFE=1)? Any > idea if one is faster than the other? I

Re: [sqlite] Multithreaded vs. serialized

2009-01-14 Thread Lawrence Gold
On Jan 14, 2009, at 4:07 PM, John Belli wrote: > Assuming I've decided to use evil threads, and am opening a new > connection in each thread, does it matter whether I use multithreaded > (-DSQLITE_THREADSAFE=2) or serialized (-DSQLITE_THREADSAFE=1)? Any > idea if one is faster than the other? I

[sqlite] Multithreaded vs. serialized

2009-01-14 Thread John Belli
Assuming I've decided to use evil threads, and am opening a new connection in each thread, does it matter whether I use multithreaded (-DSQLITE_THREADSAFE=2) or serialized (-DSQLITE_THREADSAFE=1)? Any idea if one is faster than the other? I am using SQLite on Win32 and WinCE, and I'll be using