Re: [sqlite] WAL and pragma uncommitted

ok thanks for your advice. If I use separate connections for the reading threads then is there an advantage to using "shared cache" for those connections? On 19 January 2018 at 16:35, Simon Slavin <slav...@bigfraud.org> wrote: > On 19 Jan 2018, at 4:26pm, Hannah Massey <h

[sqlite] WAL and pragma uncommitted

Currently we access a single SQLite database in a single thread but I am working on changing this as performance has become a real problem. We will be using WAL mode and there will be one thread for writes and multiple threads for reads. For many cases, speed will be of a priority and it will not

Re: [sqlite] WAL and pragma uncommitted

wrote: > On 01/19/2018 11:26 PM, Hannah Massey wrote: > >> Currently we access a single SQLite database in a single thread but I am >> working on changing this as performance has become a real problem. We will >> be using WAL mode and there will be one thread for writes and

Re: [sqlite] WAL and pragma uncommitted

is problem since I changed to having multiple reader threads and one write thread. Many Thanks in advance On 22 January 2018 at 09:37, Hannah Massey <hannah.bea...@gmail.com> wrote: > ok thanks. So looks like I'm going to try WAL mode with one connection to > the database pe