On 10/15/2016 4:21 PM, Kevin O'Gorman wrote:
So I have some questions: (1) If I do all of my updates to a temporary table, does the database still get locked?
Locked against what? What else are you trying to do with the database while the update is in progress?
Look at WAL journal mode: https://www.sqlite.org/wal.html . It allows a writing transaction to co-exist with multiple readers. See if this helps.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users