[sqlite] In-Memory database PRAGMA read_uncommitted

2016-04-24 Thread Domingo Alvarez Duarte
Hello ! I posted this some time ago, it's a program to test and tune sqlite with concurrency: https://gist.github.com/mingodad/79225c88f8dce0f174f5 Maybe it can be util to you and if you ! Cheers !

[sqlite] In-Memory database PRAGMA read_uncommitted

2016-04-24 Thread Michele Pradella
Il 2016-04-23 11:05 R Smith ha scritto: > On 2016/04/23 10:20 AM, Michele Pradella wrote: > >> I have an In-Memory DB that is written and read from connections of the >> same process. All good with shared cache, but I found that TableLock >> occur more often on In-Memory than on disk DB, probabl

[sqlite] In-Memory database PRAGMA read_uncommitted

2016-04-23 Thread R Smith
On 2016/04/23 10:20 AM, Michele Pradella wrote: > I have an In-Memory DB that is written and read from connections of the > same process. All good with shared cache, but I found that TableLock > occur more often on In-Memory than on disk DB, probably because in > memory we can't use WAL. > > Anyw

[sqlite] In-Memory database PRAGMA read_uncommitted

2016-04-23 Thread Michele Pradella
I have an In-Memory DB that is written and read from connections of the same process. All good with shared cache, but I found that TableLock occur more often on In-Memory than on disk DB, probably because in memory we can't use WAL. Anyway I found the PRAGMA read_uncommitted that from documentati

[sqlite] In-Memory database PRAGMA read_uncommitted

2016-04-23 Thread Darren Duncan
On 2016-04-23 1:20 AM, Michele Pradella wrote: > I have an In-Memory DB that is written and read from connections of the > same process. All good with shared cache, but I found that TableLock > occur more often on In-Memory than on disk DB, probably because in > memory we can't use WAL. > > Anyway