Re: [sqlite] Problem with Read/Write concurency

2011-06-23 Thread Igor Tandetnik
Natusch, Paul wrote: > In another process, I have a sqlite command line connected to the same > database, I periodically do select * from tableName; > > This causes my write to get a busy response. How do I enable > shared_cache for the command line? Shared cache works only for multiple connect

[sqlite] Problem with Read/Write concurency

2011-06-23 Thread Natusch, Paul
I have an application for which, I have one process which is writing to the database pretty frequently. I believe that I have enabled share_cache And read uncommitted. How to I verify this? In another process, I have a sqlite command line connected to the same database, I periodically