Re: [sqlite] PRAGMA read_uncommitted = 1

2009-04-14 Thread Igor Tandetnik
Joanne Pham joannekp...@yahoo.com wrote: 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

Re: [sqlite] PRAGMA read_uncommitted = 1

2009-04-14 Thread Joanne Pham
Hi Igor, I have another question : how to  enabled shared-cache mode for the connection? Thanks, JP From: Igor Tandetnik itandet...@mvps.org To: sqlite-users@sqlite.org Sent: Tuesday, April 14, 2009 12:06:29 PM Subject: Re: [sqlite] PRAGMA read_uncommitted = 1

Re: [sqlite] PRAGMA read_uncommitted = 1

2009-04-14 Thread Igor Tandetnik
Joanne Pham joannekp...@yahoo.com wrote: I have another question : how to enabled shared-cache mode for the connection? Thanks, http://sqlite.org/sharedcache.html Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] PRAGMA read_uncommitted = 1

2009-04-14 Thread Joanne Pham
From: Igor Tandetnik itandet...@mvps.org To: sqlite-users@sqlite.org Sent: Tuesday, April 14, 2009 1:29:08 PM Subject: Re: [sqlite] PRAGMA read_uncommitted = 1 Joanne Pham joannekp...@yahoo.com wrote: I have another question : how to enabled shared-cache mode for the connection? Thanks, http

Re: [sqlite] PRAGMA read_uncommitted = 1

2009-04-14 Thread Igor Tandetnik
Joanne Pham joannekp...@yahoo.com wrote: I called this function rc = sqlite3_enable_shared_cache(1); in my main program to enable the share_cache so if this process is opened any connections then these connections will be using share-cache right? Yes. Igor Tandetnik

[sqlite] PRAGMA read_uncommitted = 1

2009-04-13 Thread Joanne Pham
Hi All, I have set my database connection to PRAGMA read_uncommitted = 1.Is this allow the dirty read? Thanks, JP ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] PRAGMA read_uncommitted = 1

2009-04-13 Thread Igor Tandetnik
Joanne Pham joannekp...@yahoo.com wrote in message news:432996.36668...@web90306.mail.mud.yahoo.com I have set my database connection to PRAGMA read_uncommitted = 1. Is this allow the dirty read? http://sqlite.org/sharedcache.html Igor Tandetnik