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?
Best regards, Jaco _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
