> On Aug 18, 2017, at 2:04 AM, sanhua.zh <sanhua...@foxmail.com> wrote: > > I am using SQLite in multi-thread mode, which means that different threads > using different SQLite connection.
Actually, "multi-threaded mode" usually means using a _single_ connection on multiple threads. What you're doing — a separate connection for each thread — is effectively* the same as running multiple single-threaded processes, i.e. it doesn't involve any concurrency within SQLite. —Jens * There are slight differences, because of some global state in the SQLite library (like logging callbacks), but that's irrelevant to what's going on here. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
