> > > Yes, it does release the lock, as soon as the select is complete. You do > not > > have to do db.commit() after a select. > Please show me where that is documented. > Section 7 of http://www.sqlite.org/lockingv3.html says that ONLY > happens when autocommit is on, and you have stated that it is off > (contrary to my mistaken memory).
End of Section 4: *Once all reading has completed, the SHARED lock is dropped.* > Further, The Book says that only > inside of a Web2py app does commit/rollback back happen automatically. Commit is not needed for a select. Committing is for committing *changes*to the database -- selects only read from the database. Anthony --
