Hi Igor, I have read this document and it stated that if a database connectin in read-uncommitted mode does not attempt to obtain reaad-locks before reading from database tables. So in this case if the connection in read-uncommited modes then it allows the follwing : - concureently reads - also allows read if there is a write-lock right? Thanks again for respond my email. JP
________________________________ From: Igor Tandetnik <[email protected]> To: [email protected] Sent: Monday, April 13, 2009 9:00:12 PM Subject: Re: [sqlite] PRAGMA read_uncommitted = 1 "Joanne Pham" <[email protected]> wrote in message news:[email protected] > I have set my database connection to "PRAGMA read_uncommitted = 1". > Is this allow the dirty read? http://sqlite.org/sharedcache.html Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
