[sqlite] Multi threaded readers on memory sqlite cannot scale

2018-05-13 Thread Techno Magos
Hello I do not have clear examples to post on this but would like to report findings around multi threaded read access (single process) in a large system that uses sqlite. This may be a known issue/restriction of memory sqlite behaviour, but wanted to check with the list first: 1. Running 2, 3,

[sqlite] Crash in WAL mode, PRAGMA mmap_size=N, 2 processes (RO and RW), win64

2015-05-28 Thread Techno Magos
I cannot see the crash anymore. Will keep looking out but what you have done seems to have addressed it! Thanks

[sqlite] Crash in WAL mode, PRAGMA mmap_size=N, 2 processes (RO and RW), win64

2015-05-27 Thread Techno Magos
[ This is observed on SQLite v 3.8.10.2 but seems to occur in previous versions too) Hits under windows, 64-bit, VS 2012. Not sure about Linux, could be windows only. ] We are seeing crashes under windows in this usage pattern: Process A opens up sqlite file / WAL mode, in READ-ONLY (SQLITE_OP

[sqlite] Compile error when SQLITE_OMIT_LOAD_EXTENSION

2010-01-11 Thread Techno Magos
If building amalgamation SQLITE_OMIT_LOAD_EXTENSION then this sqliteInt.h line seems to cause the syntax error: void sqlite3AutoLoadExtensions(sqlite3*); This line should probably be within the #ifndef SQLITE_OMIT_LOAD_EXTENSION Thanks ___ sqlite-users m