On 5 Jan 2018, at 12:12pm, Lifepillar <[email protected]> wrote:

> I can make application functions access the context only for reading,
> if that matters.

Nope.  Reading vs. writing doesn’t matter.  You treat them both the same.

Nor does it matter whether you’re doing something trivial with sqlite3_vtab() 
or doing a multi-row UPDATE.

What does matter is whether all your threads are using the same SQLite3 
connection and whether they’re all using the same statement handle.  I don’t 
think you’ve made this plain anywhere, or whether it can be changed if it would 
help things.

In terms of SQLITE3_THREADSAFE, I can’t improve on

<https://sqlite.org/threadsafe.html>

Read that, do the thing in section 3, and if you have questions about it, ask 
here.

Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to