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-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] how can I disable all locking for max SELECT speed?
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 accesses take place. > How can I remove all locking overhead from this queries? Grab the lock and never let go: http://sqlite.org/pragma.html#pragma_locking_mode -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson ___ 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?
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