Re: [sqlite] read_uncommitted does not work ?

2012-01-30 Thread Igor Tandetnik
冶晶邓 wrote: > i'm using sqlite for a special mode: > 1.one process write > 2.other processes read > now i hope all read will not be blocked by write, because i'm sure the > writer won't update existing data, it only insert new data, so reader need > not wait for it. SQLite

[sqlite] read_uncommitted does not work ?

2012-01-30 Thread 冶晶邓
i'm using sqlite for a special mode: 1.one process write 2.other processes read now i hope all read will not be blocked by write, because i'm sure the writer won't update existing data, it only insert new data, so reader need not wait for it. follow the docs, i run the SQL "PRAGMA read_uncommitted