> > Again, with autocommit off: > The server process does a query/select to see if there is any work to > do. This provokes SQLite to acquire a SHARED lock. Then the server > process decides "oops, no work to do, let's go to sleep for a minute". > Notice that it does nothing to release that lock.
Yes, it does release the lock, as soon as the select is complete. You do not have to do db.commit() after a select. Anthony --
