Hi, I am using SQLite C amalgamation version 3.08.11.01 compiled for Multi Threading Mode and using WAL Journal Mode.
Sometimes I need to execute a SELECT statement which takes a very long time to complete. I realized that during that time other functions are blocked for a significant amount of time, eventually they get through after few minutes, but then, another statement/function hangs. I have seen UPDATE statements blocking and also functions like sqlite3_prepare16_v2(), open/close calls for the same database. It is usually blocking at btreeLockCarefully(). Is there something I can do to avoid such long starvations or is that by design? Thank you very much, Detlef.
