Hello !
On this snippet you can play with the parameters and find a value that
can give a good result for a workload:
https://gist.github.com/mingodad/79225c88f8dce0f174f5
I did it to test sqlite3 wall mode but it also work without it and with
disk/memory databases.
Cheers !
On 28/02/17 21:56, Matthew Ceroni wrote:
Appreciate it. Have a much better picture now.
Thanks
On Feb 28, 2017 4:48 PM, "Simon Slavin" <slav...@bigfraud.org> wrote:
On 1 Mar 2017, at 12:40am, Matthew Ceroni <matthewcer...@gmail.com> wrote:
Once PENDING is obtained, what time out value controls how long to wait
to
get EXCLUSIVE?
There is only the one timeout value for each connection: the one you set.
Each attempt to escalate the lock level can take up to the timeout value
before it returns an error code. I think. You’re at the limits of my
knowledge here.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users