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

2012-03-19 Thread Dietmar Hofer
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!

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

2012-03-18 Thread Jay A. Kreibich
On Sun, Mar 18, 2012 at 07:50:44PM +0100, Dietmar Hofer scratched on the wall: > 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. > I can guarantee that no concurrent write / read

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

2012-03-18 Thread Dietmar Hofer
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.