Table level locking is used among statements for the same connection. File level locking is used among connections. Your case is file level.
On Tue, Jul 1, 2008 at 8:00 PM, Joanne Pham <[EMAIL PROTECTED]> wrote: > Hi All, > I read the online document regarding "Table Level Locking" as below: > At any one time, a single table may have any number of active > read-locks or a single active write lock. To read data a table, a connection > must first obtain a read-lock. To write to a table, a > connection must obtain a write-lock on that table. If a required table lock > cannot be obtained, the query fails and SQLITE_LOCKED is > returned to the caller > So the question that I had is while writing the data to table(write lock) > another process can read the data from same table without any problem? > Thanks, > Joanne > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users