Would it be possible for the blocked read operations to hang for a configured "X" number of seconds (maybe with a "waiting X seconds for exclusive-mode lock to free up" message)?
This would be useful for both (1) waiting just a little bit of time to prevent unnecessary failure errors and (2) explaining to users what it going on. Thanks, - Mark -----Original Message----- From: MARTIN PHILIP [mailto:codematt...@ntlworld.com] On Behalf Of Philip Martin > With 1.8 exclusive locking the SQLite write lock is not dropped after > the first write transaction but it help until the whole write operation > is over and the database is closed. No read operations can run while > the SQLite write lock is held
