If I use the DAL select on a sqlite database to select a record then it locks the table even if no records are found. If I change it to db.executesql(....) then it does not lock the table. For example:
while not process:
time.sleep(30)
process=db(db.process.status=="pending").select().first()
If there are no records found the table stays locked so it cannot even be
viewed in appadmin.
Is this what is expected/desirable? Is there a way to release the lock?
