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!
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
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.
3 matches
Mail list logo