Re: [sqlite] how can I disable all locking for max SELECT speed?

Grab the lock and never let go: http://sqlite.org/pragma.html#pragma_locking_mode -j That was exactly what I needed. I tried with file open flag SQLITE_OPEN_EXCLUSIVE before, but that seems to be something else. 40% faster now. Thanks a lot!

[sqlite] how can I disable all locking for max SELECT speed?

I use sqlite in a mobile app with a database in readonly mode. One operation requires a lot of select-queries and should be optimized as much as possible. Profiling shows me that when scrolling the cursor with sqlite3_step(), most time is spent in sqlite3BtreeBeginTrans->sqlite3PagerSharedLock.