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!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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.
I don't know the sqlite code, but to me that looks like some locking is 
done for every query.


I can guarantee that no concurrent write / read accesses take place. How 
can I remove all locking overhead from this queries?

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users