Re: [sqlite] pragma read_uncommitted and threading

I found part of the issue, in switching servers around the test version did not enable the shared cache... My fault.. however I still recieved a RC 5 on a different write operation. Modifed the test_server code to repost the step and all was well. A better solution however is to cause the

Re: [sqlite] pragma read_uncommitted and threading

I ran everything through the test_server "server" and get the following results when using read_uncommitted=1 rc=[5] msg=[database is locked] when performing a "client_step" against a prepared select statement. I'd really like to track this down and find out if my

Re: [sqlite] pragma read_uncommitted and threading

Ken <[EMAIL PROTECTED]> wrote: > > My thought was that if i wanted to perform selects concurrently on SMP > system I would need 2 threads and each thread would be able to read > concurrently > > I just don't see how this [test_server.c] improves concurrency... > It improves write

[sqlite] pragma read_uncommitted and threading

Hi all, I have a piece of code that utilizes test_server.c, (master thread) there are 3 threads, each performing seperate tasks, that get a conection (shared) and set PRAGMA read_uncommitted=1. My understanding is that this would allow each individual thread to