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