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

Reply via email to