« Return to Thread: how can I disable all locking for max SELECT speed?

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

by Dietmar Hofer-2 :: Rate this Message:

| View in Thread


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

 « Return to Thread: how can I disable all locking for max SELECT speed?