Re: [sqlite] PATCH: updated compound query WHERE clause optimization

2007-05-19 Thread Joe Wilson
Improved patch against latest CVS with more comments and new test case attached. No regressions with make test. > This updated patch greatly improves query times against compound > SELECT statements (i.e., UNIONs) when the parent SELECT has a WHERE > clause.

Re: [sqlite] One more SQLite threading question

2007-05-19 Thread John Stanton
Doug Nebeker wrote: Yes I did the same experiment with a lock that made thread A wait until B was finished. So actually only one thread can be active at the time. I don't see how the outcome of this experiment can be of any interest, as there is no time reduction any longer. But your

Re: [sqlite] One more SQLite threading question

2007-05-19 Thread John Stanton
You can get what you want right now. It is called PostgreSQL. Ken wrote: I would be interested in a version of SQLITE that handled threading in a much cleaner way. I have a need for a single process version that is threaded. But, where SQLITE locking is concerned each thread is really like

RE: [sqlite] One more SQLite threading question

2007-05-19 Thread Dan Kennedy
On Fri, 2007-05-18 at 11:46 -0700, Ken wrote: > Dan, > Can you explain to me how within the context of the test_server.c code > that the > sqlite3_enable_shared_Cache will improve concurrency, for a single DB > file access? Others have pointed out in the past that in many cases using a