[sqlite] Performance issues in 3.5.1 (Windows)

2007-10-06 Thread patters
We've been using 3.4.2 for a while now but on drh's recommendation we've now upgraded to version 3.5.1, and have found performance to be a magnitude slower than 3.4.2. We are running on Windows CE, with memory management and threadsafe on (though disabling these does not fix the problem). We hav

Re: [sqlite] SELECT crashes with small cache?

2007-10-06 Thread Joe Wilson
--- Richard Klein <[EMAIL PROTECTED]> wrote: > I am seeing SQLite crashing during execution > of a SELECT statement when I make the page > cache very small (40 pages). > > When I bump the cache up to 50 pages, the > problem goes away. > > The problem only occurs on my RISC platform, > not on my x