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

Reply via email to