Re: [sqlite] Best settings for concurency

2017-03-25 Thread Keith Medcalf
On Saturday, 25 March, 2017 13:15, Max Terentiev wrote: > I developing app server with sqlite as storage engine. > Sqlite have many settings combinations affecting concurrency please help > me to chose right settings for my task: > 1. SQLITE_THREADSAFE 1 (serialized) vs

Re: [sqlite] Best settings for concurency

2017-03-25 Thread Simon Slavin
On 25 Mar 2017, at 7:14pm, Max Terentiev wrote: > Sqlite have many settings combinations affecting concurrency please help me > to chose right settings for my task 1. Leave SQLITE_THREADSAFE to the default setting. 2. Leave shared cache and uncommitted reads to the default

[sqlite] Best settings for concurency

2017-03-25 Thread Max Terentiev
Hi, I developing app server with sqlite as storage engine. Sqlite have many settings combinations affecting concurrency please help me to chose right settings for my task: 1. SQLITE_THREADSAFE 1 (serialized) vs SQLITE_THREADSAFE 2 (multithreaded) My app server will execute each client request