On 09/29/2011 03:17 PM, Jaco Breitenbach wrote:
Dear all,
In the WAL documentation (http://www.sqlite.org/wal.html) it is hinted that
the checkpoint operation, which is normally in the same thread if execution
as the database commit, could be moved to a separate thread or process. If
I were to run the checkpoint in a separate thread (using
sqlite3_wal_checkpoint(DB, NULL)), can I reuse the original database
connection, or will the checkpointing interfere with the ongoing processing
(inserts done in the main thread) if the connection is shared? Would it be
better to create a new connection to the database just for the sake of the
checkpointing?
Probably a new connection. All operations on a single sqlite3*
handle are serialized.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
